DLookup between two tables

[acarterczyz]

Hi all!

I'm trying to do a lookup between two tables, whereas table A includes the product ID and table B includes the price. Is it possible to create a field in table A with a DLookup function on the product ID to get the product price from table B?

Whenever I try to type in the DLookup function, it does not calculate. :banghead:

Thanks in advance!

 

[plog]

That's not how databases are to work. If you need to JOIN data, you do it by using a query.

Bring in both tables, link them appropriately, then you have access to every piece of information that relates. A query is what you need.

 

[acarterczyz]

That's not how databases are to work. If you need to JOIN data, you do it by using a query.

Bring in both tables, link them appropriately, then you have access to every piece of information that relates. A query is what you need.

Got it! Thank you!