Search results

I should have mentioned that the relationship between the machine master and the Product table is many to many. In other words each machine in the machine master can have multiple item classes associated with it. Machines 21-30 can all have item classes 43-47 produced on them.

I have a data entry/view form which has a field Machine from a table (tblMachineProduction) and a combo field ProductID from (tblProduct) which will populate the field ProductID in tblMachineProduction. I would like to have the operator enter a machine number and restrict the lookup on the...