I am working on an invoice form. This comes from a table of data in XML that holds the main details.
On my form is a table bound to this table, showing columns such as "Line Number", "Item", "Description", "Quantity", "Price", "Total" etc.
On each line, I need to add a delivery number.
Here's the challenge: In the XML, the delivery number is in a totally separate table, which has a reference to the line number of the main details.
How can I get this delivery number from the totally separate table?
What I have done so far, is create a repeating subform within my table, and data-binding to the "delivery table".
Then, I used javascript to compare "invoice line" against the "reference line number" of the delivery table it is repeating over.
If it is the same, presence = "visible", else presence = "hidden".
It feels horrid but was all I could think of. It did work, but for row 1 only.
I removed the javascipt and found it is only looping over the delivery table for the first row of my invoice. My expectation was that it would have looped it for every single row.
Does anyone have any ideas how I should be doing this please?
Thanks in advance