I've been looking all over and can't seem to find a solution. I have Custom Module API called Orders. I would like my users to select either a drop down or select box to auto populate a row on the subforms that's on this module api called Material_Orders. On the subform it has a lookup from Vendors which also has a subform called Pricelist which is already filled with their pricing and using a lookup from Products.
I would like them to select a box/drop down and it add a row on Material_Orders only pulling the Items (Lookup), Price (Currency), Unit_Qty (Decimal), Unit (Drop Box) from Subform Pricelist < Vendor. And then they can fill out other columns of color choice (Drop Down), Qty (Formula pulling from the Main Form (Orders) that will also be populated on Creation from Module Measurements). But need to take the (Qty (Formula) / or * Unit_Qty) * Price (Currency) to get total Cost per row then aggregate.

Is this possible? Unless i'm missing something and there is an easier way to do this?? I need to send material order and/or Work Order to our Vendors. But it must pull information from the Main Form Fields & Vendor Subform to be to calculate our costs and to create estimates and so on.  If someone can write this for me. I would greatly appreciate that as I've tried multiple times and nothing has worked! Let me know thanks!