When your tables and fields are in place, you’ll learn how to import Excel data into your new tables. FileMaker Pro is great at importing data from other sources. If your format isn’t supported, you can convert it to Excel or another supported format.
Finally you’ll link your tables together by creating relationships. By themselves, tables aren’t much more powerful than spreadsheets, because you can only work with the data from one table at a time — but when you link your tables together, they become aware of each other’s data. After you relate tables together, you can see and understand the connections in your data.
In this video, you will:
Create tables: set up structures for the things you’re tracking (0:49)
Create fields: define the information you store in tables (1:34)
Set field options: enter data automatically in primary key fields (2:08)
Download lesson material to follow the video tutorial: www.filemaker.com/learning/custom-app-academy/201/tables-fields-and-relationships