Access Form , if one select supplier it should show only products related to that supplier For example
Field0 is supplier code Field1 supplier and field 2 products related to supplier
Fie;d0 Field1 Field 2 Barcode
123 ABC Pepsi 1254
123 ABC 7up 1452
123 ABC marinda 5444
328 XYZ ca cola 4455
328 XYZ Sprite 14144
328 XYZ Fanta 541
747 GGC Milk 500gm 5568
747 GGC Milk 200gm 145
747 GGC Milk 1 Litre 5488
If someone on the form selects ABC by combobox than other combobox only shows item related to that supplier
like if some selected ABC than only other combox show
123 ABC Pepsi 1254
123 ABC 7up 1452
123 ABC marinda 5444
Thanks