i have an table with zipcode - place - region - country, with the combination of zipcode and place as a primary key
in the table clients i refer to this table (for my addresses)
i have a form, based on the table clients, in which i insert new clients
now i want two things:
1) when i add a new client with a zipcode - place that's allready in my zipcode tabel, i want to be able to select the zipcode, select one of the possible places, automatically fill the region and the country
2) when the combination of zipcode and place is not in the zipcode tabel, i want to add this combination including the region and the country.
Can someone please help me?
in the table clients i refer to this table (for my addresses)
i have a form, based on the table clients, in which i insert new clients
now i want two things:
1) when i add a new client with a zipcode - place that's allready in my zipcode tabel, i want to be able to select the zipcode, select one of the possible places, automatically fill the region and the country
2) when the combination of zipcode and place is not in the zipcode tabel, i want to add this combination including the region and the country.
Can someone please help me?