Subtitles of the Movie

Manage Database has two other tabs that we briefly mentioned and covered a few things about it but I want to go over it more extensively. So let's go back into Manage Database and the area that we're talking about are Tables and Relationships. But before we get there, there's a few other things I want to mention. First of all, if you are sorted by Field Name and click this, you can reverse the sort order, that's what this little icon here is for. And I want to make some notes about printing, if we select 1 field and hit Print, it's only going to select that field and print it. If we Shift Click on many fields, when we print it's gonna print all those fields out. If we select all of our fields, do a Control A on Windows or Command or Apple A on Macintosh, we have all of them selected now, then when we click Print we're gonna get all of them. So let's try that, now obviously we can't print to a printer and allow you to see it but we can go ahead and save as PDF. And we'll save to the Desktop and we'll call it Contacts-Fields, there we go, that looks good. We'll hit Save, and then we'll hide FileMaker Pro, then we'll see that PDF there and we can double click on it and we'll zoom in a little bit. And we want to scroll over there to where we can see stuff, there we go and you can see it's simply giving you all the information about those fields, their field type, all the information so that you can store it away in a safe place. Maybe you want to create a PDF and e-mail it to somebody who's working with you on the project or maybe one of your clients. Or maybe you just want to print them out and store them somewhere in case something happens to the database, you'll have a back up on paper. So let's move back to FileMaker and let's move over to the Table section. Now we briefly covered some of the things in the Table section but I want to get more intimate with it and make sure you understand, even though our Contact Manager is only going to have one Table, I still want to make sure you have some of the details about how this works so that we can plant the seed so that when we do start making more tables you feel more comfortable with it. So let's go ahead and type in a new Table here, we'll just call it New Table and we'll hit Create. You'll notice it has zero fields, zero records and we'll talk about occurrences in the Graph that refers to the relationship section. So what we're gonna do is cover all the little things you can do here. You can come in here and of course rename this, just hit change and it changes it for you. In fact it even goes and changes the Table Occurrence in the Relationship. You can sort by Table and as well as Chooser from here, Source, Details, Occurrence and Graph, all these options are there. We could choose Creation Order, Custom Order, everything's there. So usually the typical way to sort them is by Table Name but realize that Source, even though it has this up here, doesn't really allow you to sort it, neither does Details, Occurrences or Graph. These are just informational headers. And the Source refers to something we're going to get into later. Typically your Source is going to be FileMaker but it could be an external source such as ESS. The details of the Fields and the Records that you have in there and then occurrences in the Graph, we'll cover those in a second. Now again you'll also have the Print button here, want to make sure you see that. You can print all these tables if you want all the details; whatever one's selected or if you have multiple selected, that determines what's going to get printed out. So make sure you understand all the ways to manipulate this dialog as well as the Fields Dialog because in that way you can more efficiently use the space. Now there are 2 ways to look at the fields because there are fields for contacts and fields for the New Table 2. So if I double-click on Contacts, I'm over here in this section. I can come over here and double-click on New Table 2 and you can see I have no fields so I'll add some. And if you want to, you can change to Contacts and show their fields here or show New Table 2 again, it's up to you. You just want to make sure you have full mastering of this dialog so you can get around and do things cause sometimes it's easier to go up here and pop this up and choose it that way and sometimes you're over here and you just want to go to that uh, those fields for that table. So all depends on what you need to do. Now if we go over to Relationships, you're going to notice that we have Contacts and New Table 2. Now these seem to be exactly the same thing as our tables and they kind of are. The difference is you can have as many occurrences of Contacts in your Graph, which refers to the Relationships Tab, as you want. That's because this section is for Created Relationships between Tables. And really it doesn't create relationships between tables; it creates them between Table Occurrences. They're kind of like aliases or shortcuts, they're really looking at the same data in the Table but they really are defined by their relationship. And we're going to get into Relationships later, I just want to plant the seed that these are not Tables or Table Occurrences and they relate back and they're associated with those Tables but the idea behind this is to make Relationships in here and you want to remember that. So we're going to back over to Tables here and I'm going to actually delete this. And you remember this option we checked here, Also Remove Occurrence of These Tables in the Graph, well I'm not going to check it this time. We're going to go back over here and you're going to notice we still have the Table Occurrences and says the Table is missing. This kind of proves that relationship between a Table and a Table Occurrence. We don't want that to happen so let's get rid of this first, just click on it so it highlights, click the Delete key on your keyboard and then click Remove. We'll go back to Tables, we'll make New Table 3, Create It, go over to Relationships you'll see that that Table Occurrence is there. Come back, hit Delete and this time we'll say Also Remove all of the Occurrences, so if there's more than 1 it'll remove it. And you come back over here and you notice it's gone so you want to make sure you understand how that works. So again I'm just planting the seed about Relationships. Tables are easier to understand, Table Occurrences and Relationships, not as easy. But realize there's lots of buttons down here to discuss and we will get into those at later times, not right now. Also realize you can print from here so there's a lot of features that you can use becoming familiar with the features allows you to be more comfortable, it's like cooking in your kitchen. Make sure you know where the stove is and how to turn it on before you start cooking, make sure your knives are and this, anything to make things easier. So think of this as your kitchen, know where all the tools are, even if you don't know how to use everyone exactly right now, get familiar with them and we'll use them more as we go through this tutorial.