It looks like you have two relationships
customers::ID = adresses::ID_customer and customers::ID addresses = adresses::ID
Are these two different relationships or both defined in one relationship?
If they are both defined in one relationship, both have to be matching to get your data to display. To get them to fill out on the layout you described, remove the customers::ID = adresses::ID_customer from the relationship.
Thanks for your reply. I removed the second link from the relationship. So it now has just customers::ID = addresses::ID_customer.
The result is the same. The selected addresses:ID is stored in the customers record but the address coming from the addresses table is not changed on the customers layout when the selection in the dropdown box changes.
It seems that there is something conceptually wrong here.
The desired task is to select, on the customer layout, one of more addresses for customer displayed and the question is: Is the relationship in cooperation with a value list in a dropdown box the correct way to achieve this? It seemed convenient but is it the intended way to do this?
I have attached a screenshot to demonstrate that the address information is not updated with the selection in the dropdown box.
Your thoughts will be very much appreciated.
Hi again Mark,
problem solved. I just got the answer in a forum post of Filemakertoday. Here it is for the records (maybe someone later on has similar problems):
You need two relationships to Addresses: one which shows all child records of customers (this powers your dropdown list of relevant addresses, showing only addresses of this customer, and of course lets you enter new addresses in a portal etc etc); and one which ONLY shows the SINGLE related record based on the SPECIFIC address ID that you selected.
Add a new table occurrence of Addresses, let's call it SelectedAddress, to your relationship graph and set up the relationships accordingly; display that one where you wish to see the selected address, rather than via the original relationship
Thanks again for taking the the time to respond.
My mistake earlier. The way you are selecting it you would want the customers::ID addresses = adresses::ID relationship.
The drop down selection should be for the customers::ID addresses field and then should cause the address fields to update.
And yes, to create the value list or portal for selecting from all address you would need a second table occurence with a cartesan (X) relationship.
If you wanted to possibly have more than 1 address per customer or more than 1 customer per address, I would recommend adding a third (join) table, which could map any contact(s) to any address(es).