I have 4 tables:
tblItems (fields--> Item# [key], Desc, Price)
tblModel (fields--> Model [key], ModelDesc)
tblElevation (fields--> Model [key], Elevation [key], Item# [key], Qty)
tblOptions (fields-->Model[key], Elevation [key], Option [key], Item# [key], Qty)
What i want to accomplish is have someone select (i guess from a drop down) a model...then i want that to bring up all the elevations so they can select which elevation...then i want it to bring up all the options related to that model/elevation combination (note: they may select multiple options) preferrable in a check box layout
What i want to do next is take the model, elevation and options stored as selection criteria in a query...
i have done this with parameters in a query and it works fine...but i'd like to make it easier on the end user by letting them select from a list so there aren't issues with typos or trying to put in an elevation or option that doesn't belong to the model...
I've seen this type of thing done before but i've never done it...also if anyone can let me know if i have my tables and keys setup properly that would be a big help too...
Thanks in advance for your help...
tblItems (fields--> Item# [key], Desc, Price)
tblModel (fields--> Model [key], ModelDesc)
tblElevation (fields--> Model [key], Elevation [key], Item# [key], Qty)
tblOptions (fields-->Model[key], Elevation [key], Option [key], Item# [key], Qty)
What i want to accomplish is have someone select (i guess from a drop down) a model...then i want that to bring up all the elevations so they can select which elevation...then i want it to bring up all the options related to that model/elevation combination (note: they may select multiple options) preferrable in a check box layout
What i want to do next is take the model, elevation and options stored as selection criteria in a query...
i have done this with parameters in a query and it works fine...but i'd like to make it easier on the end user by letting them select from a list so there aren't issues with typos or trying to put in an elevation or option that doesn't belong to the model...
I've seen this type of thing done before but i've never done it...also if anyone can let me know if i have my tables and keys setup properly that would be a big help too...
Thanks in advance for your help...