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