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

  • 0
  • 1
  • Question
  • Updated 2 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)

Warehouse

Price

Stock


Table 2 Supervisor

UserCode (key)

Warehouse

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

Cesar

  • 0 Points

Posted 2 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 62,448 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.