If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
One field dependent upon another in one table?
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!!! |
#2
|
|||
|
|||
One field dependent upon another in one table?
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 http://mvp.support.microsoft.com/ Microsoft IT Academy Program Mentor http://microsoftitacademy.com/ "Insignia" wrote in message ... 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!!! |
Thread Tools | |
Display Modes | |
|
|