DanMcLaughlin
4 years agoQrew Trainee
Barcoding and key fields
I have 3 tables objects >pallets >and containers
When the employee add a new object they need 2 populate 2 fields
This entry goes pretty well until... Palletizing
Now I go to the pallet table and I have 2 problems
Similarly I need to associate pallets that have assigned QR codes to respective containers for shipment.
Any suggestions here are greatly appreciated
------------------------------
Dan McLaughlin
------------------------------
When the employee add a new object they need 2 populate 2 fields
- first field is a picture of the object
- second field is a barcode (number) selected randomly from a stack of preprinted labels
This entry goes pretty well until... Palletizing
Now I go to the pallet table and I have 2 problems
- I cannot lookup the barcode from the object as it is not a key field. In other systems I would set up a foreign key .
- I need the pallet record to stay open and allow me to point an click at all off the objects with the barcode scanner without additional screen commands. ( I need something akin to add new record and go to control on update) looking for ideas.
Similarly I need to associate pallets that have assigned QR codes to respective containers for shipment.
Any suggestions here are greatly appreciated
------------------------------
Dan McLaughlin
------------------------------