Join Cris Ippolite for an in-depth discussion in this video Define primary and foreign keys, part of FileMaker Pro 15 Essential Training.
- [Voiceover] So you've done everything you need to do,…you've planned out your database ahead of time,…you've figured out what tables you're gonna need,…you've gone through the modeling process,…which is your blueprint,…to tell you not only what tables you're gonna…need to find in FileMaker,…but how those relationships are gonna be defined,…and then you've done the really important last step…of the blueprint or the data modeling process,…and in your entity relationship diagram,…you've determined what key fields you need.…So now we wanna define those key fields in our tables…so that we can move on to the final step…which is actually creating the relationships in FileMaker.…
So before we do any of the other fields,…we're gonna create these key fields.…Now keep in mind we imported in…the products table,…so it's already got a bunch of fields in it,…as a matter of fact,…the products table has a ton of different fields,…and one of them that it's got here on the bottom…is this PK products ID.…So it just so happens that the table…
Author
Cris Ippolite
Released
5/10/2016- Understanding the FileMaker Pro interface
- Creating new FileMaker apps from spreadsheets
- Building tables and relationships
- Defining primary and foreign keys
- Working with fields
- Creating, editing, and deleting records
- Importing and exporting data in a FileMaker Pro database
- Creating and formatting layouts
- Finding data and sorting data
- Printing from FileMaker
- Building reports
- Using calculations
- Scripting
- Triggering scripts
Skill Level Beginner
Duration
Views
-
Introduction
-
Welcome56s
-
-
1. Getting Started
-
What is a database?2m 44s
-
Tour essential preferences6m 11s
-
Explore the interface5m 40s
-
Tour the Launch Center4m 46s
-
-
2. FileMaker App Creation Essentials
-
3. Creating Tables
-
4. Creating Relationships
-
Understand key fields6m 25s
-
5. Working with Fields
-
Understand field types7m 47s
-
Define fields8m 1s
-
Add fields to layouts5m 15s
-
Use field auto-enter options10m 5s
-
6. Working with Container Fields
-
7. Working with Records
-
Create and duplicate records6m 21s
-
Edit and lock records4m 4s
-
-
8. Importing and Exporting
-
Import data6m 44s
-
Export data4m 50s
-
-
9. Creating Layouts
-
Introducing layouts5m 1s
-
Work with layout themes7m 48s
-
-
10. Working with Layouts
-
Understand layout parts7m 28s
-
Preview the Inspector3m 2s
-
11. Formatting Layout Objects
-
Apply themes to layouts2m 11s
-
Apply screen stencils6m 13s
-
Apply gradients2m 3s
-
Understand states7m 1s
-
Set field behaviors2m 3s
-
Use the tab control feature7m 26s
-
Set the tab order3m 29s
-
12. Finding Data
-
Establish search operators5m 19s
-
13. Sorting Data
-
Sort with single criteria5m 48s
-
Sort with related fields1m 52s
-
Sort with multiple criteria1m 43s
-
Sort using custom values2m 25s
-
-
14. Value Lists
-
15. Printing and Saving
-
Print merge letters3m 54s
-
Save as PDF or Excel4m 48s
-
16. Reports
-
Create subsummary reports8m 37s
-
Add charts to reports7m 37s
-
17. Calculation Essentials
-
Introducing calculations2m 58s
-
Use number functions7m 6s
-
Use date and time functions2m 43s
-
Use text functions9m 42s
-
Use get functions4m 41s
-
Use logic functions10m 35s
-
-
18. Script Essentials
-
Tour the Script workspace3m 32s
-
Create multiline scripts8m 7s
-
Use script parameters2m 46s
-
19. Script Triggers
-
Introducing script triggers2m 12s
-
Use object-based triggers10m 22s
-
Use layout-based triggers7m 25s
-
-
Conclusion
-
Goodbye35s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Define primary and foreign keys