- [Voiceover] Every database starts by creating…the relationships first, that's your foundation…that you build upon and there's no small amount…of tasks involved with determining what…relationships you need.…You have to go through your entity list,…determine what the relationships between the entities are,…diagram those out, figure out what your key fields…are gonna be, and then define those key fields…into your database.…So, so far in the process at this stage,…what we've got are tables that are created,…our three initial tables which are the customer invoice…and products and then we determined…that we needed a join table to resolve…the many to many relationship between…invoice and products.…

So we created invoice line items.…Now in each one of these, we've gone in…and defined the appropriate key fields,…so we've got a primary key field…set up as a serialized value in the customer table.…Invoice has a primary key field,…set up to auto-serialize on it's own,…but it's also got a foreign key field…because it is the child in the customers…

Resume Transcript Auto-Scroll

Author

Released

5/10/2016

Learn how to design and build smart, secure databases with FileMaker Pro 15—the business solution used everywhere from home offices to Fortune 500 companies all around the world. Cris Ippolite, drawing on years of experience with clients at his own development firm, iSolutions, walks through essential FileMaker Pro skills, from creating tables and fields to designing layouts that display your data in a smart way. If you need help navigating FileMaker Pro for the first time, watch the opening chapters, which cover database basics. Cris also shows you how to find and sort data, create reports, import and export data, and write scripts and calculations—everything you need to build your first database with FileMaker Pro 15.