Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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
That is exactlly what i did StockCode as StockSalesKey .....ast FilteredStocRequested....
Do you think this is the most efficient solution??