Related Drop Down List
Not new to databases, new to FileMaker..
I have one database containing 2 tables, Contacts and Companies. One company can have several contacts. I have related them through CompanyID. When a new contact is entered, I would like for them to select the company from a drop down list. But I want the drop down list to show a calculated field CompNameDiv(Company Name + Division Name) that they choose from, and store the appropriate CompanyID with the Contact record.
My first attempt was using a value list that used the Value from CompanyID and showed the value form the CompNameDiv. This did not work, as the record reverts back to showing the CompanyID.
I think that the issue is that there is no company yet related to a contact, and therefore, it has nothing to display?