Hi
I am asking for help in the following. I have a table with services: customers and locations and services (Services). One customer has more locations. This is stored in another table (CustomerLocations). I would like to make an input form where i pick the name of the customer from a combobox based on CustomerLocations. But when i pick a name i would like to be offered in the location field only those locations that belong to that specific customer. How can i do it?
thanks
I am asking for help in the following. I have a table with services: customers and locations and services (Services). One customer has more locations. This is stored in another table (CustomerLocations). I would like to make an input form where i pick the name of the customer from a combobox based on CustomerLocations. But when i pick a name i would like to be offered in the location field only those locations that belong to that specific customer. How can i do it?
thanks
