Populating field data from one table to another
Please forgive me if this has already been posted (I have searched) and redirect me to the appropriate post if it exists.
I have 2 tables. Accounts and Contacts.
Accounts has address fields and company name. I want the address details to be automatically populated in the Contacts table once I select a company name. I already have _Id_account in the Contacts table and vice versa. They are linked in the relationship graph TOC, however I cannot get it to work.
Any help would be really appreciated.
Also I am a very new user to FMP.