I have a form/query, on click this form saves the data to a table and then a query is run updating the records. We use this to mark products that have been shipped as "shipped". I am having 2 issues.
user enters DeID Base (Account) then the bag/box number, then the user needs to enter the the product shipped witch starts with the DeID + 4 numbers usually starting with 1001. I have the DeID and Box set to default = to the de ID base and box previously entered but the table does not populate the first records but does in the second. Screen shot in yellow.
I want a pop up warning if the user enters one DeID but by accident scans a different product for a different customer. Like the DEID is 1001ABC and the user scans a product with code 1234ABC1001, which should be going to client 1234ABC. Example in screenshoot in blue.