Repeat Selection within a repeat selection

Hi,

I am not sure how to go about this or even if dataassist will help, so here goes...

I have a hand built page which is basically an invoice, 1 record. Within the invoice their are multiple products and services, multiple records.

I have been requested to allow my customers to select as many invoices as they need to print out and be able to print them all from the one print page. So that would be one page, with multiple invoices containing multiple products and services.

So from my experience with dataassist I remember it doesn't like repeat selections within repeat selections.

Do you guys know of a possible work around or even a solution.


Thanks


John Henderson

Gosh this dataassist is brilliant, It has allowed me to repeat the invoices and has the repeated products and services within the invoice repeat selection.

Only thing is the products are not being displayed. The products are retrieved from a separate recordset to the invoices. So some how It needs to pickup the relevant invoice id from the invoice recordset.


just thought I would keep you up to date with my progress


john

I have a feeling the answer is in my sqlcode here.

SELECT *, DATE_FORMAT(datecreated,'%d %M %Y') as printdate
FROM invoice
LEFT JOIN customers ON customers.customerid = invoice.invoiceid
LEFT JOIN products ON products.invoiceid = invoice.invoiceid
LEFT JOIN preferences ON customers.prefid = preferences.prefid
WHERE invoice.print = '1'

This actually produces five records in total, there are only 3 invoices so the five products are linked to the 3 invoices. But to get the correct number of invoices i need to use the Group By function for Invoices, but then I lose the correct number of products and services.

john

your going to need to use 2 separate record sets.

one to return the invoices and another to return the products.


the products record set will need to be inside the first repeat slection loop and filter using the value returned from the invoices recordset.


If you are comfortable hand coding PHP code and creating recordsets, this should not be to difficult to accomplish, if you are not comfortable hand coding PHP, I would suggest signing up for a premier ticket where you could work one on one with an engineer to create the code.