Can someone explain what does the Reference field mean when building a relation

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

I have two table Replacement and CostPerUnit

what i want to do is find the cost of replacements for a particular quality 

Photo of Esha

Esha

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of Blake Harrison - DataBlender

Blake Harrison - DataBlender, Champion

  • 100 Points 100 badge 2x thumb
We'd need quite a bit more information regarding your application and what you're trying to accomplish to assist on your goals, but I can answer your question on Reference Field. The Reference Field is simply the field that allows a Child record to be associated with a Parent record. In most relationships, the Key field for the Parent is the Record ID#. When you build a Relationship from the Parent to a Child table, the Reference Field - typically named Related Parent - is the Record ID# of the Parent record that the Child record belongs to.
Photo of Esha

Esha

  • 0 Points
Thanks Blake..
I have two table
1. Station
fields are: station name (same for all the records), Location, Quantity, Item, cost and owner

2. Cost per unit
fields are: Item, costperquantity and owner

I need to build a relation between there two tables to find the cost of the total quantity for each item.
I am building a relation as follows:
one cost per unit can be associated to many stations.

The reference field used in the relation is the Related Parent. However, the cost shows a zero when i do that.
But it does when I use quantity as a reference but the data is wrong
Photo of Blake Harrison - DataBlender

Blake Harrison - DataBlender, Champion

  • 100 Points 100 badge 2x thumb
Are these the only two tables in your application? For the Cost Per Unit table, where is this information derived from and what are you trying to track? Same question on the Station table - what are you trying to track and does each station need to be able to have multiple Items?

Typically, CPU is calculated based on multiple factors and would probably be dependent upon Time or Purchase Orders, so that as you purchase inventory, your Cost Per Unit fluctuates as your Purchase Cost per PO changes.