Derive the field value from another table

Question

HelloCan you please help me write the QB formula for below region derivation?Say there are two tables&nbsp;1. Sales table:Customer&nbsp; Region Sales1001&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; NA&nbsp; &nbsp; &nbsp;$1001002&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;SA&nbsp; &nbsp; &nbsp; $2001003&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;EU&nbsp; &nbsp; &nbsp; $3001004&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AS&nbsp; &nbsp; &nbsp; $400How can derive Region from customer table. if it is Excel, I would have written as If(VLOOKUP(Customer,Customertable(Customer:Country),2,false)="US", "NA"If(VLOOKUP(Customer,Customertable(Customer:Country),2,false)="MX", "SA"etc2. Customer tableCustomer Country&nbsp;1001&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; US&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1002&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;BR&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1003&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;FR&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1004&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;IN------------------------------Siva------------------------------

markshnier__you · Answer

Normally your application would be set up with a relationship where one customer has many customer sales. Simply look up the value of the country code from the customer table down to the sales table.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

Forum Discussion

Derive the field value from another table

1 Reply