Hi all, 

I’ve attached a DB/Form im compiling to do a simple intake form for stock holding, Consignment Number needs to be unique, when inputting the TM_Carton_ID on the subform i want it to look up against the DB and bring back if its Pure or mixed, but i cant seem to get it to happen for multiple lines. 

See my attached DB, any help on this would be useful, feel free to add any additions too, once this is live the TM_Carton_ID will be scanned in via a device and we need to tell the user if that carton is a pure carton or a mixed carton. 

any help would be great on this thanks.

DB is below.
 https://drive.google.com/file/d/1UgD7rwVlKIe_0EHKlDQ2TWqhkbwyLzBx/view?usp=sharing 

​Hi all,  I’ve attached a DB/Form im compiling to do a simple intake form for stock holding, Consignment Number needs to be unique, when inputting the TM_Carton_ID on the subform i want it to look up against the DB and bring back if its Pure or mixed, but i cant seem to get it to happen for multiple lines. See my attached DB, any help on this would be useful, feel free to add any additions too, once this is live the TM_Carton_ID will be scanned in via a device and we need to tell the user if that carton is a pure carton or a mixed carton. any help would be great on this thanks.DB is below. https://drive.google.com/file/d/1UgD7rwVlKIe_0EHKlDQ2TWqhkbwyLzBx/view?usp=sharing   Read More

​