Search and get info from other table, if lookup record is not the primary key

I imported a report from a supplier webpage (table Quotes). This report is a list which contains Customer ID, Quote #, Product ID, Product Name, and other features. Each Quote # could have several Product ID´s.

On the other hand, I created a table with Designs. Each design is associated to only one product ID.

I want to get the info associated to the product ID, like Name, dimensiones, etc, from the Quotes table, but the primary key (first column) in Quotes is the Customer ID.

How can I search and get info associated to a specific Product ID? Something like VLOOKUP function in Excel, where I can search a specific data and get the info in the next columns.

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.