I am very new to FileMaker, and am creating my new database. I took the "Basics" course, and am now creating my first solution from scratch. Most importantly, I want to ensure my tables and relationships are setup appropriately. My issue right now is that I have created a one-to-many relationship between 2 tables (Accounts and Contacts); and cannot seem to get the foreign key field in the Contacts table to populate with the primary key field from the Accounts table. In this specific case... I am trying to do the following:
- When I create a new Contact, and then select which Account the said contact belongs to (from a Value List on the Account field), I simply want that Contact to be linked to that Account. This way, when I view a specific Account, I can see all the Contacts tied to this Account via a portal. I currently have an Account Table with only 3 records (1 for each account, each with a unique ID), and then a Contact list with about 20 records where I'd like each contact to be tied to one of those 3 Accounts. Does this make sense? Maybe I am over complicating it?
Thank you a great deal for any help in advance, there is no question FileMaker is a program with limitless functionality, the light bulb just hasn't turned on yet!