One field dependent upon another in one table?

[Insignia]

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!!!

 

[Jeff Boyce]

If you are intending to work directly in the table, step back for a moment.
Unlike Excel, where what you see (in the spreadsheet) is what you get,
Access tables (although they look like a spreadsheet) are simply "buckets o'
data". They are not intended (nor designed) for display use. That's what
forms (and reports) are for.

If you want to limit the possibilities of what gets put into the [Property]
field (by the way, this word is probably reserved in Access, so Access may
decide to do something you didn't expect if you use that word), do so via a
form.

Use a combobox to pick the value for [License], then add an AfterUpdate
event that requeries the combobox you use for [PropertyX]. The [PropertyX]
combobox needs to be based on a query that looks to the first combobox to
find a selection criterion for [License], thus limiting the values returned
for [PropertyX].

Good luck!

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/