Thank you for your post.
This is a common question from users, and we usually direct everyone to Knowledge Base Article #5833.
If you have any difficulty with this article or still can't get this to work, please let me know.
Dear TSGal..., thanks very much that resolved my issue.
now that one side works....i have another challenge:
i have populated a list say with geographical zones, A, B, C etc, a 2nd list with customer names in those zones. with your earlier help i was able to set it up in such way that when i select zone A in one field, i would only see the customer names in another filed that are in zone A. If i change to zone B then the pull-down menu would show all customers in zone b and so forth...this works well now.
however i have also made fields with more details for each customer, such as address, contact numbers etc. what i would like to happen is that when say i select zone a in one field, then choose the relevant customer in the next field, that now all additional details are looked up and automatically filled in. In define data base i have for example selected customer address => look up, and defined the look up value with the matching "address" field. however for some reason filemaker now always just fills in the details of the 1st address of the whole customer list under zone A (or zone B, or whichever zone i chose). i.e. instead of using the customer name as refernce for the look up, it chooses zone as the look up.
if you have any advice here, i would be very thankful again!
It's your relationship. Your lookups need to come from fields in the customer table related by customer, not zone.