Hi it possible for lookup in 1 column to be dependant on the lookup on another columns depending on what is clicked in a form to make it easier
brand table
field 1: Number auto
field 2: Drink linked to lookup table called
drinks
field 3: type of drink linked to lookup table called
subdrinks
Drinks table
Pepsi
Coke
other
Subdrinks table
original coke cola
diet coke
coke with vanilla
coke with lemon
original pepsi
diet pepsi
persi max
pepsi with lemon
now in a form looking at the brand table. the person clicks on Drinks = picks coke from drop down menu
what I need is if the person picks on coke the next drop down menu type of drink it should only show those related to coke.
original coke cola
diet coke
coke with vanilla
coke with lemon
what i am getting is the second drop down shows everyhting and if the user makes a mistake the reports ie chose coke but in the next field chooses diet pepsi, the data does not make any sense. is there any way to limit the second drop down based on the choice in the first drop down.if there are any ideas to help in this matter maybe some VBA or macro may be required, i am not too sure open for suggestions and help would be appreciated.
Thanks
brand table
field 1: Number auto
field 2: Drink linked to lookup table called
drinks
field 3: type of drink linked to lookup table called
subdrinks
Drinks table
Pepsi
Coke
other
Subdrinks table
original coke cola
diet coke
coke with vanilla
coke with lemon
original pepsi
diet pepsi
persi max
pepsi with lemon
now in a form looking at the brand table. the person clicks on Drinks = picks coke from drop down menu
what I need is if the person picks on coke the next drop down menu type of drink it should only show those related to coke.
original coke cola
diet coke
coke with vanilla
coke with lemon
what i am getting is the second drop down shows everyhting and if the user makes a mistake the reports ie chose coke but in the next field chooses diet pepsi, the data does not make any sense. is there any way to limit the second drop down based on the choice in the first drop down.if there are any ideas to help in this matter maybe some VBA or macro may be required, i am not too sure open for suggestions and help would be appreciated.
Thanks
