Look up field value in another table based on formula.

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
I have a table used for data entry with a formula that kicks out what product to use on a job. 

I need to bring in that product's Cost Per Unit from the Products Table to calculate how much the job will cost. 

How do I do this? 

Photo of Evan


  • 266 Points 250 badge 2x thumb

Posted 1 year ago

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

QuickBaseCoach App Dev./Training, Champion

  • 67,328 Points 50k badge 2x thumb
No problem,
In the products table set the Key field to be the Product name.

Then make a relationship where 1 Product has Many order lines and make the connection in the right side of the relationship using your formula product name field.

Then lookup the Unit Cost.

I suggest that you then make a snapshot field which would be a numeric field type to freeze the value the lookup.

Here is some help on relationships


Here is some help on snapshots