Skip to main content
Question

Look up field value in another table based on formula.

  • April 7, 2018
  • 0 replies
  • 73 views
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
    This topic has been closed for replies.

    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...
    Terms & ConditionsAccessibility statement