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

Determining which key fields you need - FileMaker Pro Tutorial

From the course: FileMaker Pro 12 Essential Training

Start my 1-month free trial

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…

Contents