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...
Forum Discussion
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.
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.
