I am working on an inventory system for a tool rental shop. I have two tables: Details and Tracking. Details has all the basic information about all the customers (Name, Barcode, ID etc.). Tracking is meant to create a log of rental activity.
Here's what I am trying to do: I am trying to scan a barcode and input the barcode to a form based off the Tracking table. However, once the barcode field has been filled in, I want other fields like Name, ID etc. corresponding to the entered barcode to be pulled up from the Details table and filled automatically in the form.
I was thinking of some expression like Name = Barcode.[Details]!Name and so on, but it does not work. Can anyone help me out with this? Thanks a lot.
JJ