Forum Discussion

EvanBohan's avatar
EvanBohan
Qrew Cadet
7 years ago

Look up field value in another table based on formula.

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
Ask about Quickbase functionality
Relationships
Tables and fields

1 Reply

Sort By
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    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...