Hi! I am very new to Infopath (2007), and I´ve been managing to get things to work using this forum (very handy, by the way, thanks).
I am having a problem with something, and I think it could be related to that preceding-sibling, but I´m not sure. And if so, this has been asked frequently here, but I couldn´t get it to work by applying the solutions. Maybe you guys can help me out on this. I think this has a very easy solution, but I can´t get it working, so i´ll try to explain the problem the best I can.
Background: the company sells construction material (marble tiles) to clients, generating an invoice (products to be delivered at a later time, due to construction site schedule). The unit product is in squared meters, so there can be mutiple shipments for the same invoice (variety a in one day, variety b next month). Every shipment generates a so-called "delivered-materials-report". Another thing: while the client is building, there may be more than one invoice (someone discovered the original order wasn´t enough).
Objective: A "ordered-goods X shipped-goods" form, where half the page lists all invoices for a client´s construction (product and quantity only). The other half of the vertically split page shows all shippings. And below each there is a sort of summary, an outline of everything the client bought, and everything the company has already delivered (and what still needs to be delivered).
PURCHASED MATERIALS
Invoice 1
Material Sq2
marbleA 10
marbleB 20
Invoice 2
Material Sq2
marbleA 3
marbleC 2
----------------------------------------------------- and this is what I need below (if I get this working, ill get the rest of the form working too)
PURCHASED MATERIALS OUTLINE
Material Sq2
marbleA 13
marbleB 20
marbleC 2
(this is what it should be like.. the outline must show only one of each marble type, and the sum of meters from all invoices.. but I can´t get this to work)
1) the material-sq2 is a repeating table, inside a repeating section (so user can add another invoice to the form).
2) purchased materials outline is a repeating table.
My datasource is like this:
clientcontrolform
........purchasedmaterials (group) (repeating section)
..............invoices (group)
..............idinvoice (field)
..............individualinvoice (group) (repeating table)
.....................purchasedmat (field)
.....................purchasedmatsq2 (field)
........purchasedmaterialsoutline (group) (repeating table)
..............purchasedmatoutline (field)
..............purchasedmatsq2totaloutline (field)
Basically, i need to populate the purchased materials outline with a single entry of each marble..