Nested combo box
in [Tables]
|
From: OceanSeventyTwo on 13 Nov 2009 15:12 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
From: Jeff Boyce on 13 Nov 2009 15:38 Search on "Cascading Comboboxes" Regards Jeff Boyce Microsoft Access MVP -- Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or pseudocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. "OceanSeventyTwo" <thomas.m.canty(a)gmail.com> wrote in message news:b15766ab-17cf-4070-8254-556c3851f3cd(a)a21g2000yqc.googlegroups.com... >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
|
Pages: 1 Prev: Table design help! Next: Suggestion - Make a new section for Templates & Example Databases |