R
Robbie
Hi
I have three combo boxes from a table called tbl_CUSTLDDNLD
tbl_CUSTLDDNLD
A B C
ChlRef -Plant - Item
LLL309 AAA 14285
LLL309 AAA 14265
LLL309 BBB 14270
LLL310 AAA 14285
LLL310 BBB 14270
LLL310 CCC 14281
I would like BOX B to only show data applicable to the
selection in box A so if LLL309 is selected then box b
will show AAA and BBB and from that selection say AAA Item
14285&14265 will be available for selection in BOX C.
this is to be out into a form which will update a new
table.
many thanks
Robbie
I have three combo boxes from a table called tbl_CUSTLDDNLD
tbl_CUSTLDDNLD
A B C
ChlRef -Plant - Item
LLL309 AAA 14285
LLL309 AAA 14265
LLL309 BBB 14270
LLL310 AAA 14285
LLL310 BBB 14270
LLL310 CCC 14281
I would like BOX B to only show data applicable to the
selection in box A so if LLL309 is selected then box b
will show AAA and BBB and from that selection say AAA Item
14285&14265 will be available for selection in BOX C.
this is to be out into a form which will update a new
table.
many thanks
Robbie