hello
if the user of my database selectes a county for example bedfordshire how could i get it so that then in the town column it would display a drop down list with only the towns in that county.
thanks
hello
if the user of my database selectes a county for example bedfordshire how could i get it so that then in the town column it would display a drop down list with only the towns in that county.
thanks
The concept is called cascading combos. I have a demo of the two most common methods here:
Baldy-Cascading Combos
Note that this doesn't work too well on continuous or datasheet forms.