I am designing a database to track all of our listing information for a
large
range of products that are sold to retailers.
I have created a field in the main table called "License" where the user
is
given three options. THe field right next to License is called "Property"
where I'm hoping to make the options dependent upon what is chosen in the
License field. To explain this a little better, it would be like a user
selecting province/state, then their next selection would have
cities/towns
in the state/province that the selected.
I'm not sure how to do this properly...any suggestions??
Thanks SO much in advance...I'm going crazy trying to figure this out!!!
