I have created an app for Quotation Purpose. In my App I have a parent table "Customer"and multiple child tables “Products which are filled for the customer” Eg: Window Blind,Curtains,Curtain Rod etc.
Once all the information is filled I want to create a summary table for the user where in together they can see the information which shall have fields such as Room,Item Name,Qty,Rate for the products filled across multiple product tables. These fields do also exist in the individual product tables.
I did try this by creating another Quote detail table and then trying to use concatenate formula to merge information from multiple tables. But it didn’t come row wise and all the information filled say for example in Room column in multiple tables was filled in a single field.
If I can get some guide on how to achive this would be very helpful.