2 Replies Latest reply: Jun 19, 2013 6:24 AM by Nikolaos Kavroulakis RSS

    Synthetic key problem

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