Print summary page combining multiple DBs

[kmerritt]

I have created a relational database that tracks the travel of different people on a theatrical show. One database holds air travel info, another hotel info, a third handles car info and then a master DB which contains all the traveler's personal details. I want to be able to print a one page summary of all the travel details for each person, but I am not sure how to approach it. I view all this info through portals in browse mode from the Main DB. Should I just try to set up portals on my print page and do it that way.

Is there any way to create summary layouts in all the different databases and then merge them into one report for each traveler. My ultimate goal is to be able to set up a script that will create a one page summary for each traveler that I can then Print to a PDF and email out.

Thanks for your suggestions!

-Kevin

[BobWeaver]

You can print portals but it's generally not recommended if you can do it another way (ie., from the related files). You would need a print script in each file, and then call them sequentially from a main script in the main file. To combine them into a single PDF would require a bit of extra work external to Filemaker.

[Ugo DI LUCA]

...Or join all records into a single line item database...and display a subsummary by Customer_ID.

[kmerritt]

>...Or join all records into a single line item database...and display a subsummary by Customer_ID.<

Would you do this on the fly as the print script is called? As somwhat of a newbie I am not sure exactly how I would do this. Do you know of any links to other threads or tutorials that might explain this approach. I am very curious about this solution.

---------------------

-Kevin

[Ugo DI LUCA]

Hi,

One database holds air travel info, another hotel info, a third handles car info and then a master DB which contains all the traveler's personal details.

It seems to me that if you set up a trip for a customer, you would likely use a join file to enter all these details.

The Customer details would use a portal to that Line Item db to view records.

You would need a "line" with each of your foreign keys field.

The structure may be as the following :

Some lines may have both the Travel_ID and Customer_ID fields filled and all others empty,

Another line would have Travel_ID, Customer_ID and Car_ID filled.

Another line would have Travel_ID, Customer_ID and Hotel_ID filled.

As you see each line can be related to the Customer_ID and in that case the Travel_ID field (could have been a Travel Order_N

[kmerritt]

I think I get it. I will give it a try and let you know if I have problems.

------------------

thanks, Kevin