Wonder if someone can confirm if the following is possible, and if yes then how to do it.
Backgroung: I've setup a table call 'Towns' to how hold list of all towns, and in the customer table the town in the customer address is a key e.g 20 which is e.g. 'Dover' in the Town table (20 = Dover). So I create a query that links key to the value so the what displays is 'Dover' - basic stuff.
Problem is that I what the Town field on the customer form to be a combo box, for two reasons:
1. If 'Dover' is wrong user can select from list of Towns and right Town - And want the key of the new town to save to Customer table
2. If setting up new customer can select town.
I'm OK with reason two, but how do I get the combo box that is populated from Table 'Towns' to display the 'Town' of an existing customer, so it can be change if needed.
Hope this make sense
Many thanks
Backgroung: I've setup a table call 'Towns' to how hold list of all towns, and in the customer table the town in the customer address is a key e.g 20 which is e.g. 'Dover' in the Town table (20 = Dover). So I create a query that links key to the value so the what displays is 'Dover' - basic stuff.
Problem is that I what the Town field on the customer form to be a combo box, for two reasons:
1. If 'Dover' is wrong user can select from list of Towns and right Town - And want the key of the new town to save to Customer table
2. If setting up new customer can select town.
I'm OK with reason two, but how do I get the combo box that is populated from Table 'Towns' to display the 'Town' of an existing customer, so it can be change if needed.
Hope this make sense
Many thanks