I have a DB with a SQL backend. There are three tables linked. I'm trying to use a barcode scanner to enter info quickly into a form. When I scan the Work Order number I'd like the description, date entered, due date all auto-filled. I was trying Dlookup but didn't have any luck.
Is Dlookup my best choice here? Or are there other ways to go about this?