AnsweredAssumed Answered

Getting primary field serial number to display in foreign key field in different table

Question asked by vcdpp on Jul 6, 2011
Latest reply on Jul 6, 2011 by vcdpp

Title

Getting primary field serial number to display in foreign key field in different table

Post

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.

Help? Thanks!

 

DPP_Database_question.png

Outcomes