Not an easy question to answer without knowing a great deal about the design of your database. Why do you need different layouts in the first place?
What are you trying to produce from this "collection"? Printed Hard copy? a Single PDF file? or ???
Phil, I have data in 5 different tables. Each of the tables has unique layouts. I want to "collect" this data into a "complete catalog" PDF, where the info from each table maintains its own layout. I've been trying to do this with Find and Sort functions but, so far, no luck. Ideas?
I understood that you had different tables, but am asking why you have different tables--this might not be necessary and if you can get it all into one table--things get much less complicated.
Take a look at the 'append to existing file' option for the Save As PDF script step. With it, you can save as PDF from layout 1, switch to layout 2 and save as PDF and append it to the PDF from layout 1 and then repeat for each additional layout.
There's a built in limitation here: Each appended PDF starts a new page--which may or may not work for what you want here.
I need to revisit this issue and find an elegant solution. I have 5 Tables, each with unique records. Records from each Table will print using just one unique layout. I need to "collect" all the records from All the Tables and create one PDF. My Table & Layout names are attached.
I'm assuming this is going to be a script containing various "find" and "constrain" elements, but I'm not sure where to start. Would a global checkbox field inserted in each Table/Layout help? (Something like "Include in Catalog?)