Expand all | Collapse all

table to table relationship

  • 1.  table to table relationship

    Posted 07-18-2018 13:59
    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.

  • 2.  RE: table to table relationship

    Posted 07-18-2018 14:49
    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.