Hide Caption
Show Caption
Now that we've added our Housekeeping fields to keep track of the creation date
and time, the modification date and time, and the count creation and
modification, we're ready to go ahead and click OK. And you'll notice when we
click OK that it automatically adds those fields to Layout. This is a nice
feature when you're starting out, but eventually this becomes annoying and
actually can ruin your database. You can actually turn this option off in
Preferences. So if you go to Preferences, and remember, on Windows it's under
the Edit menu and go to Layout section, you'll see that you have this checkbox,
and if you uncheck it, newly created fields and defined database will not be
added to the current layout. So, why can this be detrimental to your database?
Well, there's several reasons. First of all, those fields may not really belong on
the layout you're currently on, so do you really want them to be added there?
You'll just have to grab them and put them somewhere else. You may not even want
those fields on any layout, in fact. You may just be using them in a script, so
they may not be display fields, so adding them should really be your choice. In
fact, it could actually ruin your layout. If you already have the interface and
everything, what will happen is it will actually push down the body parts and we
haven't talked about the parts of Layout mode yet. But what it'll do is push
down the body parts and you'll have to remove those fields and move them back up.
So, in general, I would say it's not a good idea to have this option on because you
should really add these fields yourself. As you'll see when we get into Layout
mode, you'll actually start adding these fields in ways so that you can keep the
same format to the fields and so this option may not necessarily use that
format, so it's really a good idea to do this manually, even though it seems
like it may take more time, it actually will save you time in the long run. So
we'll click OK here, and we're going to go back to Manage Database, and what we
want to do is cover some of the other options in here and see how things work.
So let's look at the DOB field and let's say we want to change that to, oh, let's
say, a text field. You'll notice that it doesn't make the change until you hit
the Change button. Same this is true if you wanted to add some type of comment.
It doesn't update until you change it. On the other hand, if you go into Options
and choose Creation Date, you don't have to change it, it just automatically
applies. So these are things you'll just get used to as you're going along. Now,
you can also delete fields. If you hit Delete and tell it to delete, and it asks
you this question - Do you want to permanently delete the selected fields? Well,
it permanently means it's gone. I mean, when you delete something from defined
database in the Manage Database area, it's gone from everywhere, so if we hit
Delete right now, and don't discard, click OK, you'll see that the date of birth
field actually disappears off the layout. So we'll go back in there, Manage
Database, we actually want to add that back in there. So we'll type in DOB,
make sure it's the right type, and hit Create. Now, it adds it on in the end
because it's displaying everything in creation order. Now, we can also
duplicate fields, let's say you needed another field for time stamps or
something for accounts, or maybe you needed Address 2. We can go to Address,
change that to Address 1, and change it. and now we can make a second field for
Address that would maybe carry your suite number or an apartment number, or
additional address information that wouldn't fit on one line. Well, what we can
do is we can actually duplicate that. Now the nice thing about duplicating is
it actually will keep all of your options, so in the case of duplicating Time
Stamp Create, you can actually go ahead and duplicate that and make very few
changes to it to get it to be Time Stamp Mod. All you'd really have to do is
change Address, take that off there, make that a 2, notice that the Change
button is not available until we change that. FileMaker's smart and know you
can't make two fields with the same name, and we just hit Change, and now you
have Address 2. So it's up to you how you do things. Now one of the things you
can do is move this up there so it makes more sense. And you'll notice that it's
changed to Custom Order over here. But we'll get more into that in a few
minutes, but realize that you can change the order of these fields so it better
suits the way you're looking at your information. Now you can go back to
creation order, and it'll go back to where it was, or go back to custom order,
and now you're looking at the way you designed it, the way you want the fields
to appear in this dialog. So, what we can do is work with this, now I want to
make sure that what we did before when we cancelled, we hit that Cancel button
and we hit Discard. When you discard, make sure that you really wanted to
discard all that stuff. Because maybe we wanted to get rid of Address 2, but
what we also got rid of was the Date of Birth here, so you really have to
remember when you click that Discard button all the things you've done in here,
it's not going to give you a list of what's been done so you can check it. So
make sure you really know what's going on, so now we have to add the DOB field
again because it removed Address 1 and Address 2 but it also removed DOB, and
that's what we want, so we're going to stick with just the regular Address
field here and go from here.