Hi all, I'm trying to use a list view to print (save records as PDF).
Usually when I use this it works find with a line items table, however for my invoice section I don't use line items (as you can only add one record from the main inventory to one invoice). So the print layout is basically another view of the same table. On my invoice layout I have a portal to my inventory (artworks). These records get added as normal by a fk and pf (fk in artwork and pk in invoices).
All works fine however when I go to list view print layout I only get the first record in the artwork portal on each invoice- no good if the invoice has multiple artworks on.
Do I have to use line items or is there a way around this?
Attached is a pic of my relationship table in case that's helpful to see.
For my consignment section I use a script (attached) which works fine but as mentioned I can't seem to use this as my print layout for invoices is based on the same table.
Any ideas welcome, thank you!