Report from 2 related DB

[soriano]

HI:

I want make a report from 3 related DB but I can't, I want make information from PAcients DB and PricesA DB and PricesB DB in one DB call it reports DB, the master DB is Pacients DB.

The report is the next:

Pacients::Name

PricesA::date

PricesA: :payment

PricesB::date

PricesB: :payment

I don't have any relation with the third DB (reports) can I make this report or could you suggest me somethin else?

Thanks for you help

[ June 18, 2001: Message edited by: LiveOak ]

[LiveOak]

The best way to approach this is to eliminate the Reports database and print your report from the PricesA database using related information from the Pacients database and using a subsummary by pacient to separate and title the records by pacient.

-bd

[soriano]

Thanks for your answer but I don't know how make this relation, could you tell me how can I make it?

Thanks