Are the tables in the same data area? Have you considered creating a conditional lookup (similar to CUST_NAME) for both columns (i.e. PROD_FAM_NO, and SALES_ORD_LN_NO) with Sales_Ord_No as the join field?

Dear @Karankadam ,

To me it looks like making a look up from the PROD_FAM_NO to the SALES_ORD table is a mismtch in granularity. The PROD_FAM_NO is on a sales order line level where the sales order table is on a sales order level. So in this case the PROD_FAM_NO table should be the main table and you need to look up from the SALES_ORD table. lowest granularity table usually is master). or you need to do look up with a aggragation in it. but you cannot look up the SALES ORDER LN to the SALES ORD table and not aggregate.

Let say you really NEED to do this, then you can create a view and join the two tables which will result in a duplication of rows in the SALES ORD table by the amount of SALES ORD LINES echt SALES ORD has.

Hope this helps

= Daniel

Hi @Karankadam has this issue been resolved? If so can you please help us by marking a best answer above? If you have any follow up questions, please let us know