Determining which key fields you need


show more Determining which key fields you need 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 ...

Determining which key fields you need

Once you've completed your data modeling exercise, you will have determined what tables you are going to need in your FileMaker database, as well as what relationships you are going to need between these tables. Since we've already gone into our FileMaker database, and we've defined the tables that we need - we've talked about four tables that we need to define - we need to now create relationships between them. Now what we need in order to create relationships is something that could hook these two tables together. So each table has got to have a little hook in there that allows it to connect itself to another table that it's related to.

In relational databases, you're going to connect two related tables together using special fields that are called Keys. A key field is just like any other field you are defining in your database, but key fields come in two different types: There is a Primary Key and a Foreign Key; two more pieces of vocabulary for you to wrap your ...

Determining which key fields you need
Video duration: 5m 18s 9h 11m Beginner

Viewers:

Determining which key fields you need 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 ...