View Single Post
  #1  
Old November 13th, 2009, 09:12 PM posted to microsoft.public.access.tablesdbdesign
OceanSeventyTwo
external usenet poster
 
Posts: 1
Default Nested combo box

I have a database where I have a combobox field that you can pick the
raw materials that are used to make up a product.....


[ RAW MATERIALS V]
__ 11111111111
__ 11111111112
_X_ 1111111113
_X_ 11111111114


But each raw material has a list of alternatives, but not all are
approved for every product that uses that raw material. So i need a
nested combo selection to choose which (if any are approved
alternative for that product)


[ RAW MATERIALS V]
__ 11111111111
__ 11111111112
_X_ 1111111113
___ 2222222221 // from approved alternatives list in Raw
material table
_X_ 2222222222 // approved alternative for this Raw
material for this product
_X_ 2222222223 // approved alternative for this Raw
material for this product
_X_ 11111111114
___ 3333333333 // none of the RM alternatives are
approved for this specific product
___ 3333333334
___ 3333333335



Please Advise

Thanks

Tom