Help on Table relationships

by mkj   Last Updated April 16, 2018 04:06 AM

I am working out a dashboard on which I am bringing good number of data. Need help on perhaps a basic question on table relationship:

I have two batches of a raw material, A and B. In first manufacturing sub process, these are converted to say A1, A2, B1 and B2. Next sub process convert these 4 sub products to A11, A12, A21, A22, B11, B12, B21, B22.

I have created 3 tables, one for raw material and 1 each for these 2 sub processes as below: Image showing tables and related items

Next, in Data>Relationships, I created as shown in image and then I create Pivot1. Although, I created relation between RawMaterial as primary key tblRaw and tblSub1, but pivot1 shows all 4 sub1 items in both A and B which should not be the case.. Next, I add LengthSub1 in this pivot as pivot2 and then data is correctly interpreted.

Next, I add third table tblSub2 as Pivot3, and again correct interpretation of relationshis is missed.

Can someone kindly guide me what is going wrong here.

Many thanks for your support.

Related Questions

Table design best practice for multiple user type

Updated August 10, 2016 08:04 AM

In a Database, What, exactly is a Record?

Updated October 04, 2017 11:06 AM

Best name for link table

Updated May 18, 2016 08:02 AM