G
Guest
I have two tables that have barcode items I’m trying to create a query or
form that will allow someone to scan out items from either table on one
screen.
Example would be a car dealership table 1 cars, table 2 parts.
Table 1 Table 2
Field 1 Always unique Barcode (Car) Field 1 many repeating Barcodes
(tires, ...)
Field 2 Sales person Field 2 Sales person Same in both tables
Currently I have a datasheet for each table that works, but you must enter a
different datasheet to checkout items from the other table. I would really
like to have one form that I can scan barcodes and sales person reputedly
creating new records in each table. (the scanning is done with a wireless
scanner away from the computer, so having multiple fields in a form will not
help. I need two fields only)
Example
Scan
Field1 Field2 Table
Barcode Barcode 1
Barcode Barcode 2
Barcode Barcode 2
form that will allow someone to scan out items from either table on one
screen.
Example would be a car dealership table 1 cars, table 2 parts.
Table 1 Table 2
Field 1 Always unique Barcode (Car) Field 1 many repeating Barcodes
(tires, ...)
Field 2 Sales person Field 2 Sales person Same in both tables
Currently I have a datasheet for each table that works, but you must enter a
different datasheet to checkout items from the other table. I would really
like to have one form that I can scan barcodes and sales person reputedly
creating new records in each table. (the scanning is done with a wireless
scanner away from the computer, so having multiple fields in a form will not
help. I need two fields only)
Example
Scan
Field1 Field2 Table
Barcode Barcode 1
Barcode Barcode 2
Barcode Barcode 2
have an awesome day