How to select a value from another Table column when a condition meets the criteria.

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I need to get a column value from another table field nonetheless the the key used in on of the table is different to the another key in the another table.

Example : 

Table 1 Inventory

Imei (key)




Table 2 Supervisor

UserCode (key)


Supervisor Name

This is a similar kind of table that I have, I need to basically   pull  the supervisor  name to show in the Table 1 Inventory.

How ever since both keys are different I wont be able to pull the supervisor name associtate to the warehouse.

Note: Warehouse are numeric fields

Photo of Cesar


  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,760 Points 50k badge 2x thumb
You will need to have a table of warehouses where the key field of the table is the warehouse.  That table will need to have the supervisor's name.

Then make a relationship down to the inventory table based on the warehouse field in the inventory table, where One warehouse has Many Inventory records.