I'm working on an Access 2003 form that has the following fields: ItemNo, Packaging, Amount
The table where this data is: myTableA and has the fields: ItemNo, Packaging and Amount.
When the end user enters the ItemNo I want the combo box to show only the packaging options the item does NOT have in myTableA already. Each ItemNo must have 3 packaging levels: EACH, PACK and CASE
For example, let's say in myTableA I have:
So if the end user enters ItemNo: 123, then the combo box should only show CASE.
If the end user enters ItemNo: 456, then the combo box should show EACH and PACK
If the end user enters ItemNo: 789, then the combo box should show EACH, PACK and CASE
Thank you in advance!