From the course: FileMaker Pro 12 Essential Training
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
Determining which key fields you need - FileMaker Pro Tutorial
From the course: FileMaker Pro 12 Essential Training
Determining which key fields you need
So far in the process, we have discussed the concept of tables and then defining keys inside those tables so that you can create relationships. Keys are critical to building relationships in your FileMaker Database. So the next step will be understanding which of the tables that you have defined in your database will need to have these key fields added. So let's take a look at the tables that we have been talking about so far in this title. And we will determine what types of keys they might need. Here is our entity relationship graph where we've got the customers table, the invoices table, the invoice line items, and products. If you remember, the primary key decisions are easy. Every table acting as a parent needs a primary key. Let's look at which tables are acting as a parent in one to many relationships. We can see that customers is a parent to invoices, so it will need its own primary key. Invoices are acting as a parent to invoice line items, so it's going to need its own…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
Understanding relationship types4m 9s
-
Diagramming relationships with entity-relationship ER diagrams7m 7s
-
Understanding key fields4m 19s
-
Determining which key fields you need3m 11s
-
Defining primary and foreign keys4m 54s
-
Creating relationships using the relationships graph and table occurrences5m 35s
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-