Hello,
I am working on a simple database to do a physical inventory in a warehouse. I have a table with 3 fields, PartNumber, PackageID, and Location.
I have a form where the user will scan the data from each package linked to those fields on the table. The barcode data that they will be scanning has a unique prefix for each data type. For example, part number begins with P, location begins with Z, and package ID starts with S, M, or G.
I need to find a way to have an error message pop up and not allow the entry to be saved if the scanned data does not match the prefix required for the field. Is there anyone that could assist me with this?
Thanks in advance
Steve
I am working on a simple database to do a physical inventory in a warehouse. I have a table with 3 fields, PartNumber, PackageID, and Location.
I have a form where the user will scan the data from each package linked to those fields on the table. The barcode data that they will be scanning has a unique prefix for each data type. For example, part number begins with P, location begins with Z, and package ID starts with S, M, or G.
I need to find a way to have an error message pop up and not allow the entry to be saved if the scanned data does not match the prefix required for the field. Is there anyone that could assist me with this?
Thanks in advance
Steve