Conditional Value Lists V.9

[jasonboes]

Hi,

I am using Filemaker Pro v.9 Advanced. I have database I need to get done and am having a hard time with the relations for a conditional value list. It is based off of the Issue Tacking sample that comes with the software. So what I have done is created some tables. There is the issue traking. Then I created a Company table, Address Table and a Contact Table. What I am trying to do is if a company is entered and it is already in the list it can be chosen. That works fine. But each company could have multiple Addresses and some are overseas. So in the Address Table I have these fields: Company, Attention, Address, Address2, City, State, Zip, Country, and Contact. The Company Table has Company. Now each Address for Each Company could have Multiple Contacts. So I created a Contacts Table with the Fields: Name, Phone, and eMail. So if you can see I want to be able to select the company on autoenter if it exists and populate the address. But if there are multiple addresses I would like to select the address or type in a new one, which the new one would be included in the future. And if the address exists and is chosen be able to chose the contact if there are multiple ones for those addresses. So if anyone knows how to help I would appreciate it. I have been looking for example but haven't found any yet.

Jason Boes