ACCOUNT CONTACT ADDRESS
ID_Account >--< ID_Contact >--< ID_Address
Company? NameFirst? Address01?
CompanyType? NameLast? AddressCity?
Contact is related to Account
Address is related to Contact
Account is a Company with an Address that multiple Employees share?
Company has multiple locations? Maybe a Locations Table related to Companies?
Address is company address or Contact personal address?
What you describe is called a conditional value list. Have you read the info in these links? Or checked out the demo file?
Forum Tutorial: Custom Value List?
Knowledgebase article: http://help.filemaker.com/app/answers/detail/a_id/5833/kw/conditional%20value%20list
If you still have question after all that, feel free to ask them right here in this thread.
Account is really a company. It has many contacts (employees), and many addresses (locations), not personal. I want to be able to attatch many contacts to the same address (location), or if you prefer the same address to many contacts.
At Phil, I will check out the demo File, thanx.. I have found most of those threads you just shared links to, but I think I need to walk away for a few, my head is twisted reading everything and trying to figure this out. I think after I let my head clear up for a few I may start to get a clearer view.
Ok, I have the value list working for selecting wich account I want to filter the the address value list with, but can't seem to get the conditional list working.
Please describe the exact relationships you are using, the table occurrence on which your layout is based and the specific options selected in Manage | Database | Fields.
Are these the relationships you have?
Contacts>----Account----<Addresses (---< means one to many)
Contacts::AccountID = Account::AccountID
Addresses::AccountId = Account::AccountID
Yes. That is exactly what I have.
Yes, but I asked for a few more details than just confirming the relationships.
Please indicate the table occurrence on which your layout is based and exactly what options you selected in Manage | value lists for the conditional value list.
You may discover the need to attach one person to many companies and so on. The best method of doing this is to use an inbetween table where the account and person id are saved in a record. This many to many table will accomplish what you want.
Another method seldom discussed, except by me, is to use a text field to hold the unique ids of the related file. This is the simples storage method but can be messy if you need to clean up and the first idea is best.
You can link a portal to the inbetween file and drag the other file's fields onto it, since they are related and no one's the wiser.
After stepping away for a few hours, I came up with a solution for what I was trying to accomplish, and it will actually works better and easyer for me. I reconfigured my relationships, and built a search popup layout that populates with records containing similar data to my search criteria and a button next to the records that allows me to relate the address to the contact. I have a button on the contact page next to the address field that activates the popup window, and I just start typing in the search field and the window starts populating with similar data.