From the course: FileMaker: Relational Database Design
Join today to access over 22,500 courses taught by industry experts or purchase this course individually.
Defining primary and foreign key fields - FileMaker Pro Tutorial
From the course: FileMaker: Relational Database Design
Defining primary and foreign key fields
- [Instructor] So one of the many benefits of going through the data modeling stage before you start creating your databases is that you know things like what tables you'll need, which we've already done in the previous movie, we've created those. And then also you'll know what key fields you need. Mostly it boils down to figuring out which tables are going to be parent tables, in one-to-many relationships, and they need primary keys, and then which of the tables in your relationships are going to be acting as child tables, those of course need foreign keys. Now what's nice about FileMaker is that when you create a new table you'll see that there's a series of different fields that are already created for you. So for example we have Customers, Orders, LineItems, Products already created, and you'll notice all of them have what are called default fields. Now for the most part, default fields are really just housekeeping fields. I strongly recommend you keep these in here, they're going…
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.