Subtitles of the Movie

Manage Database has two other tabs we briefly mentioned but we want to cover them more extensively now. That would be the Tables and Relationship sections but before we do that, I want to hit the Cancel Button here. Now, we talked about in the last section about how we can get out of the issue where we deleted the Address 2 Field, remember, it's gone here? In fact, if you remember, we also went ahead and created this Time Stamp Mod 1 Field. So how do we get that back even though it's at this point really permanently deleted? We have one more failsafe method to get it back. If you hit Cancel here and then hit Discard, all the changes since we last opened up Manage Database will be gone. The last time we opened it up was we went into Layout Mode and we added all the fields and layouts so you should have been out of Manage Database already. If you come back in, that's starting a new session so it's going to discard all of the things you did from that session if we click that. If you just hit Cancel, you're back to this dialog. But we're going to hit Cancel here, hit Discard, then go to the File Menu and choose Manage Database and notice that everything's back to the way it was. We now have Address 2 back and Time Stamp Mod 1 is gone. And in fact, a lot of things are back to the way they were. Creation Order is now set, not Field Name. We'll change that and now we're ready to go ahead and talk about these other tabs. Now, they're not as important right now because we're not really using additional tables and we're not really creating relationships right now but I want to give you an idea what these areas are about so you can be prepared for them when we get to them in the intermediate section. So we'll go over to the Table section and what you want to know is how to create a new table. Well, it's real simple. Just type in New Table or whatever you want to name that table and hit the Create Button. It's much like creating a field. And if you want to change it, well, you go ahead and type the changes and hit the Change Button and it changes it. And you'll see that it lists up here the different tables, the source. Now, the source is going to be FileMaker all during these tutorials but your source could be an external source like ESS or using ODBC but we're not going to cover those in this tutorial so all of your sources are going to be from FileMaker but it could change. Then you have your Details. Well, we have 15 fields in Contacts and one Record. Zero fields in New Table 2 and zero Records and then we have Occurrences and Graphs. This refers to the Relationships Tab and we're going to cover those in a second but if you have more than one occurrence of this table in the Relationship Graph, it'll list them, as many as it can fit on here and it'll put a comma and you can and list as many as it can across the screen. If you have a large screen you can obviously see more. So that's very important to understand how relationships work but I'm just planting the seed right now. Don't worry if you don't understand what an occurrence is and what a relationship can be used for. We're just planting seeds and giving you like a little bit of detail here so you can get prepared for when we do cover this. It's not the most important thing right now. Let's cover more about how this dialog works. Notice that you can come over here and click on Table Name and sort it and notice that these really do nothing up here. They're just headers so they don't really sort. But you can view by table name, table name and creation order, table name alphabetically or custom order if you rename, you know, rearrange them. So it's a lot like how things work in Manage Field section. So we can really apply the same ideas here. So there's a couple of things here. You do have the Print Button. Again, it works the same way as your Print Button in the Field section. Whatever is highlighted prints so make sure to remember that. And another little nice little trick is you want to get very efficient with this dialog because you'll be here for a long time. You know, you'll be using it quite a bit. You want to get efficient with it and one of the quick ways to get to the Field section is double click. If we come over here and double click on Contacts, we're now in the Field section. We can switch up here to New Table or we can come back here and double click on New Table and come in here but it all depends on how you want to get there. It may be faster if you're here to switch there or if you're over here, to go into this section this way. So you want to become familiar with all the little ins and outs here that you can. So let's go under the Relationship section and cover that a little bit. Now, in the Relationship section you're going to see that you have Contacts and New Table 2. Well, they appear to be your table, they're not really. They're actually table occurrences and you can kind of identify that if you hover over this little arrow here. It'll say your source table has contacts and your source table is New Table 2. They just happen to have the same name but they're more like aliases or shortcuts if you're familiar with those in your system software. The shortcuts or aliases or as we call them in FileMaker, the occurrences or table occurrences are really defined by the relationships between the tables, which we are not covering right now. But you can draw a relationship line between these and so you can have more than one relationship between a table so therefore you need occurrences in that table to find all these different relationships. But again, don't worry about it if you don't understand how this works completely because we're just planting the seed. It's going to take a while to build up to this and understand that and so when we get into the intermediate tutorials, that's when we'll start covering relationships. Just remember, these are not tables, these are table occurrences. They represent that table and the purpose is so you can create relationships. Now you can delete these table occurrences and they have no effect on the actual table. But if we go over to the Table section and we try to delete it here, it'll ask you do you also want to remove the table occurrences? Well, let's not check that option and hit Delete and we'll see here that we now have a table occurrence over here with the table missing. It relies on that so we'd actually have to click on it and hit the Delete Key to get rid of it. So if we actually come over here and say New Table 3 and create it, notice we have it over here in the relationship, come back here and this time Delete like we did the very first time we did back when we were briefly going over this. This time we're going to check that option and you'll see that now it's gone. So you very often most likely want to check that, Delete the occurrences out of there. There are certain exceptions to that and we're really not going to find out right now because you have to understand how a relationship works. But that's the basic idea. You want to understand how all this stuff works. So we've got tables, fields and relationships. What you really want to understand is the field section at this point. If you understand that, you're doing perfectly fine. If you understand a little bit about how tables work and maybe even a little bit less about how relationships work, well, don't worry about that. It's not that important but remember how to interact with it a little bit. That's what you want to get out of this tutorial right here.