Discussions

Expand all | Collapse all

Look up field value in another table based on formula.

  • 1.  Look up field value in another table based on formula.

     
    Posted 04-06-2018 22:01
    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


  • 2.  RE: Look up field value in another table based on formula.

    Posted 04-07-2018 13:58
    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...