I have a Purchase Order (PO) table connected to Cost Items (CI) table. In the PO form, there is an embedded report for users to easily add items (see photo 1).
There is also a section in the form for Billing that shows the same embedded report where they can input Bill % and all of these bills should be in the Bills table. Every Bill record can contain any of the cost items assigned with Bill % until it reaches 100%.
For example:
Bill #1 - contains CI#1 with 60%
Bill #2 - contains CI#1 with 40 %, CI#2 with 50%, CI#3 with 70%
Bill #3 - contains CI#2 with 50%, CI#3 with 30%
