Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

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

192 0
Showing results for 
Search instead for 
Did you mean: 

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.

0 Replies 0