As shown in figure, Sales Ord Is My Base Table, and second table is Sales_ORD_LN_PROD_FAM,
what i want to do is, Fetch PROD_FAM_NO,SALES_ORD_LN_NO column in to Sales Ord Table,
Sales_Ord_No is same column in both Table,
Is there any way to do it,
Best answer by daniel
View original
+5
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?
+5
Dear
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
+5
Hi
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
