Creating a Database / Housekeeping Fields pt. 2
Subtitles of the Movie
We could also go ahead and import these, so we're going to go to the Tables section. You only have one table, FileMaker created this table for you based on the name you gave to your file, but you can create other tables over here, and you can even import tables. So let's choose Import, locate the template, and if you see this Import log, that is from the copy and paste. Every time you use a copy and paste or an import, it creates a new log called Import Log and tells you what happened. This is just a way you can go and check on if there's an error, what might have happened. Now, if you were to have an Import Log at the same location as your file, well then it'll just add to it, so we won't get another one here. I usually just delete them, I don't look at them very often, they can be a little bit annoying, so we'll eventually get rid of that. But, if you opened it up in a text editor, you can see all the things that happened when you did all this stuff, so it's a good way sometimes, to recreate what you copied and pasted. Who knows, it could be useful. So we're going to choose Template, you'll see that there's the table, there's only one in there, I'll check it. You could bring in multiple tables, we'll click OK. We have this Import Summary, now you could open that log that I just showed you from here, but really, there's no need because there's zero errors. That's really the only important thing here. So we'll click OK, and notice now we have this template with the four fields. If we go to the Fields section, you'll see that the template is right in here. All those fields imported. Now, what you could do here is rename this. Just change that and now you could change and all the fields you need, like it might be an invoicing table. So you could repeatedly import these tables, now again, this Import option is only available in FileMaker Advanced, so if you don't see it, again, you're going to have to do this manually. But thankfully, in this case, we actually don't need this, it was just a demonstration, so let's hit Delete and get rid of that. Go back to Fields, notice that that table is gone now, we can't choose the fields for that table, and this is what we want to end up with. We want to have the Time Stamp Create, Time Stamp Mod, Account Create and Account Mod all what we can't modify on Auto Entry.
Tutorial Information
| Course: | FileMaker Pro 9: Beginner |
| Author: | John Mark Osborne |
| SKU: | 33783 |
| ISBN: | 1-933736-95-X |
| Release Date: | 2007-07-26 |
| Duration: | 12.5 hrs / 145 lessons |
| Work Files: |
Yes |
| Captions: | Available on CD and Online University |
| Compatibility: |
Vista/XP/2000, OS X, Linux QuickTime 7, Flash 8 |
VTC Sign up & Benefits
- Unlimited Access
- 98,729 Video Tutorials (23,265 free)
- Video Available as Flash or QuickTime
- Over 1026 Courses
- $30 for One Month Access
- Multi-User Discounts Available
United States 