table to table relationship

  • 0
  • 1
  • Question
  • Updated 5 months ago
  • Answered
i have 2 tables. 1st is the master list that contains all the part numbers. 2nd is the scrap data table that has scrap data for all the part numbers. now both the tables have part number as the common field but the problem is in both the tables the part numbers are exported from different excels although its the same part numbers. i want to have a column in the master list table showing total scrap cost for that part number, the value for which can be taken from the scrap data table. I am not ale to figure out how to do that.
Photo of rachit kalra

rachit kalra

  • 100 Points 100 badge 2x thumb
  • confused and frustrated

Posted 5 months ago

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

QuickBaseCoach App Dev./Training, Champion

  • 53,570 Points 50k badge 2x thumb
You will need to ch age the Key field of the Master list t be the [Part number] field.

Then make a relationship to the scrap table and use its [Part number] field on the right side of the relationship.

Then you will be able to make a summary field on that relationship of the total scrap value.