AnsweredAssumed Answered

Display companies on another table

Question asked by MortenJoergensen on Feb 7, 2013
Latest reply on Feb 11, 2013 by MortenJoergensen

Title

Display companies on another table

Post

     Hi there.

     So I created a database containing almost 200 contacts on one table. Each contact has a company associated. I want to make another table with just the companies, so the same company doesn't appear twice. Also, I want it to bo automatic so when i create a new record on the contact table and associate it with a company, it automatically updates the company table with a new company, is that possible?

     The other thing is, when i create a new record on the contact table and want to associate it with an already existing company, how can i get FileMaker to auto-fill the data so i just need to put e.g. the company name?

     With regards

     Morten

Outcomes