How to MERGE 2 INVOICE PDF into 1?

Question:
I’m working on automating invoice creation in Tadabase.

In TABLE 1, I have multiple records where different Manufacturers (Manufacturer 1 & Manufacturer 2) are assigned to the same Sales Rep. Currently, when I generate invoices in TABLE 2 (Invoice Table), it creates separate invoices for each manufacturer, even though they share the same Sales Rep.

How can I automate the process so that only one invoice is created per Sales Rep, even if multiple manufacturers are assigned to them in TABLE 1?

Would appreciate any guidance on how to structure this automation efficiently. Thanks!

Maybe I’m just having a mental block here but help me understand this setup?

Could you provide screenshots or a loom that shows how your invoice is working now? And maybe also how your data tables are structured?

Which table is the parent and which is the child? If you’re trying to set up an invoice with multiple manufacturers then the table with manufacturers has to be a child of the Invoice table.

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.