Loading an Access form with data

0
votes

I am designing a database with there tables: Product, Customers and Test records.

Each product has a customer assigned. Hence, in the product table, I have a customerID field/column. In the test record, each record has a product. Hence the final Test record table will have ProductID and CustomerID.

On the form I have created a dialogbox which is displays, the product name and customer name. The sourcerow is from the Product table. However, what is stored is the ProductID and customerID. The product and customer names are displayed in two unbound fields.

Question. When retrieving record from the test table, do I need to do an onload script to process the value of the ProductID and CustomerID or is there a more efficient way?

enter image description here

1
ms-access

1 Answers

0
votes

You could either use a DLOOKUP

=DLOOKUP(Field, Domain, Criteria)

https://599cd.com/tips/access/dlookup-function/

Or create a Query that uses the IDs to join to the other Tables then pull in the names you want to see.