Records that contain several sub items
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 fo...
Forum Discussion
Hi there. The second embedded report is the same one under PO Cost Items section except there are additional columns like Line Item Bill Summary, Bill % and Bill Amount. Currently, this doesn't work because for every Bill % assigned to a cost item, it should create a record in the Bills table. I need help how it should be set in the Bills table with this example below. So it's like every Bill record can contain 1 or more cost item with the assigned Bill %. Let's say today, I wanna bill for cost item #1 for 60% then the next day, I wanna bill for cost item #1 for 40% (already 100%), cost item #2 for 50% and cost item #3 for 70%. These are all under a certain Purchase Order (PO). I should be able to do the same for any PO as every PO can have more than one Cost Items.
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%
What is your table structure look like? How are these connected, Parent, Child and the Many to Many?