To create a report from multiple databases, is the only method for doing this creating several reports from each different database and merging them together with Word?

thanx

I have several databases (none of which are subrecords of eachother) that contain different information, the only commonality between them being a client's ID.  However, I would like to combine all the data from the various databases for a particular client ID into one report directly into Word.  Is this possible?

Thank you.

Erika has a final say as she is an expert and probably the one designed the Report part of Sesame.

But I know one thing, that you can do practically anything with Q&A.  If you can do that in Q&A, you probably can do it in Sesame also and probably there is an easier way to do it in Sesame. 

If you just need data from a few elements from other database "derived" column will allow you to get those values in the report using X-family functions. How many derived columns can we have in Sesame? I do not know.

You can also make one layout with all different elements you need to have in the report. Use X-Family functions to get the values from the other applications, manupulate the data as you need to using programming in the form. All this can be automized and done on the fly using macro and Mass Update with all the programming done in Form Entry Event.  (In Q&A, it can be accomplished using one nested macro)

Then make out report based on this new layout and take it in MS Word from browser.

I am not upto speed with Sesame yet, but the principle is the same.  The question is, how often do you have to make this report?  If it is frequently and routinely, it is worth the effort.

so to clarify, in order to generate a single report from multiple databases, I will have to use XLookup to retrieve each field from the different DBs?

what if i have databases A and B where each DB contains a client ID. A contains the client's info such as name, address, etc and B contains the purchases a client has made.  can i use X-family commands to retrieve all the records from B on the condition that the IDs match between both tables?

thanx