Re: repeating table gets unique value from another repeating table within a repeating section

Shiva — Sat, 20 Dec 2008 07:43:32 GMT

Hello,

This is duplicate forum of below,

http://www.infopathdev.com/forums/p/10144/36091.aspx#36091

repeating table gets unique value from another repeating table within a repeating section

daniloraf — Wed, 17 Dec 2008 20:08:42 GMT

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..

Newbie Questions

Re: repeating table gets unique value from another repeating table within a repeating section

repeating table gets unique value from another repeating table within a repeating section