Look up field value in another table based on formula.

  • 0
  • 1
  • Question
  • Updated 7 months 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? 

Thanks,
Evan
Photo of Evan

Evan

  • 266 Points 250 badge 2x thumb

Posted 7 months ago

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

QuickBaseCoach App Dev./Training, Champion

  • 51,316 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

https://help.quickbase.com/user-assis...

Here is some help on snapshots

https://help.quickbase.com/user-assis...