Recent Articles
Article #129 Download sample file
There's a better way to manage your contacts

This database demonstrates techniques relative to associating people with companies.

Person Selector

Click the "+" button on the Company layout and you'll see the Person Selector layout. This technique is easier to use than a drop-down list when you have a lot of person records in the database.

The Person Selector layout is displayed in a card-style window, which is a new feature in FileMaker 16.

Company - Person Join Table

Instead of assigning people to a company directly, we use what is called a join table. This table stores associations between companies and people.

FileMaker Forever is a resource for FileMaker enthusiasts. Come here often for tips and sample files to help with your own projects. Created by Brent Durland with Swingtree Consulting