Getting primary field serial number to display in foreign key field in different table
Three days of FM Pro classes but this one is stumping me.
My Company table has a primary key field that automatically assigns a unique serial number to each company.
I want my contacts to reflect the company they work for, using that primary key as a foreign key, correct? When I put in a new contact I would like the company that contact works for to display in the contact field. I know I'm missing a key step -- how do I tell FM which company they work for?
Here's a screen shot with my early start at relationships (bottom right), contact (left) and company (top right).
Caroly works for CA Strawberry Assn. I manually put in the CA Strawberry Assn code but that seems wrong, and the Company Name (from Company table) doesn't populate.