Defining primary and foreign keys


show more Defining primary and foreign keys provides you with in-depth training on Business. Taught by Cris Ippolite as part of the FileMaker Pro 11 Essential Training show less
please wait ...

Defining primary and foreign keys

Once we've gone through the process of determining which key fields we're going to need in our database in order to create our relationships, the next step is going to be to go in and define those fields inside of the FileMaker databases. So if we open up our Exercise File/04_ 04, we see that under File and Manage > Database, we've got our four different tables created. So let's start first with defining all the primary keys in the tables that are going to act as Parents, and if we look back at our list, we determine that the tables that are going to have primary keys are going to be Customers, Invoices, and Products.

So let's start with Customers. First, in your Manage Database window, you'll notice that under the Tables tab, if you select a Table and double-click on it, it's going to navigate you over to the Fields tab. And normally there will be a list of all the fields, but since we haven't defined any yet, we see that we've got a blank list. Our...

Defining primary and foreign keys
Video duration: 7m 56s 9h 11m Beginner

Viewers:

Defining primary and foreign keys provides you with in-depth training on Business. Taught by Cris Ippolite as part of the FileMaker Pro 11 Essential Training

Subject:
Business
Software:
FileMaker Pro
Author:
please wait ...