FILTER DIFFERENT TABLE DATA INTO ONE VIEW

[AVDHESH]

I HAVE ONE TABLE NAME “DATA” IN WHICH I HAVE ONE COLUMN “NAME OF PRODUCT” IN APP I AM FILLING THE FORM AND ENTERING DATA AFTER THAT IN MY ALL PRODUCT VIEW WHEN I AM CLIKING THE PRODUCT ITS DIRECTLY OPEINING THE DETAIL VIEW OF THAT PRODUCT WHICH IS PERFECT BUT NOW I WANT TO ADD A ANOTHER TABLE “BOM MASTER” IN WHICH ITS HAS ALL RAW MATERIAL NAME WHICH IS USED TO MAKE THAT ITEM THE TABLE HAS ONE COLUMN NAME ITEM AND ANOHTER IS RAW MATERIAL.

I WANT TO SHOW ALL THE RAW MATERIAL INTO SAME DETAIL VIEW OF THAT PRODUCT I CLICK USING LOOKUP OF NAME OF PRODUCT IN DATA TABLE TO ITEM IN BOM MASTER

RAW MATERIAL CAN BE 2,3,5 ETC

BELOW TABLE IS DATA

BELOW TABLE IS BOM MASTER

AND BELOW UPDATE DOCUMENTS I NEED ALL THE RAW MATERIAL WHICH IS UESD TO MAKE THAT ITEM

[lynchk21]

The picture of your BOM TABLE is too low resolution, so I cannot see how it is set up. But in theory, you will just need to have a reference between your DATA table and your BOM TABLE (Assuming your BOM TABLE is a list of materials for each product). Then you can display the BOM TABLE as an inline view in your DATA detail view.