Forum Discussion

rachitkalra's avatar
rachitkalra
Qrew Member
7 years ago

table to table relationship

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