reference data field in another table for calculation.

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I have an App I am attempting to setup as a data sync reference pool.  I am having trouble actually referencing it though.  In the Data Sync app I have cost tables.  I have another app called Inventory Management that I have an Obsolete form step up.  I want to lookup standard cost of a part once the part number is entered on the form to use in a calculation to get value of the inventory being obsoleted.  Any help or suggestions please?

Photo of Randy

Randy

  • 0 Points

Posted 3 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 62,438 Points 50k badge 2x thumb
Can you tell me the Key field of the table which has the Part Costs?  Is it Part#?
Photo of Randy

Randy

  • 0 Points
Okay, I figured this out myself.  I was looking at the lookup field from a "pull" perspective rather than setting it up right in the table relationship.  I imagine the tutorials would have shown me this.  Sorry.  

Anyway, once the lookup field is in place it will act just like a value field in the form.  I can use it to calculate in a numeric formula filed [Quantity On Hand] * [Cost Record - StandardCost].  Quite simple.