Cross-Table Report Formulas
I am using QB in our manufacturing facility and am trying to get an order-by-order bill of materials. Specifically, I have a table for "Raw Goods" (the raw materials we make into parts), "Parts" (the ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendYou will need to have a proper child table to the orders.
One order has many Order Raw goods BOLs.
That will be a new child table to Orders.
You can use an Automation to copy across the correct Assigned Goods which match the part ordered to create these when the order is created and the part has been selected on the order.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
One order has many Order Raw goods BOLs.
That will be a new child table to Orders.
You can use an Automation to copy across the correct Assigned Goods which match the part ordered to create these when the order is created and the part has been selected on the order.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Awesome. Worked like a charm. Thanks!
------------------------------
Kiel Berry
------------------------------
------------------------------
Kiel Berry
------------------------------