Synthetic key problem

[#1]

Hi QV community,

I have a synthetic key in my model as you can see in the image attached.I know that i can resolve it by buy connecting StockCode of StockSales table to StockSalesKey is a duplicate filed of StockCode in FilteredStockRequested. As FilteredStockRequested contains only a small subset of stock codes(40 codes) it is not a major waste of resources to have this duplicate key.StockSales and StockFreeStock contain full records of stock codes about 800 But I feel this in not the most efficient solution.Any other proposals???

I have attached the granularity of the related tables as well...

Regards,

[#2]

Hi

Pls Try Below...

Table 1
StockCode

Table 2
StockCode,

StockCode  As  %StockCode

Table 3
StockCode As %StockCode

{Table 1 & Table 2 [Link Field StockCode ]

Table 2 & Table 3 [Link Field %StockCode ]}

Regards-Bika

[#3]

That is exactlly what i did StockCode as StockSalesKey .....ast FilteredStocRequested....

Do you think this is the most efficient solution??