data from two unjoined databases in one report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two databases - one details of residents and second details of events of the organisation. I want to generate a report that displays events from both databases especially on the anniversary of an event (eg. DoB) of a person or the organisation. How do I create a report that can use both the databases?
 
Nathan

You could link the table you need from one database into the other, and then build your report in the second database, drawing information from both databases.

Bob Sullivan
 
Hi Bob
Thanks for the reply. I've created a link to the table tbIndividualdetails from database RRR.mdb into the database Diary.mdb. However when I create a report in the Diary.mdb database using Wizard and try to include both tables tblIndividualdetails and daybyday of Diary.mdb it tells me that the tables are not related. How do I proceed?
Thanks
 
Hi Bob, once agai
The tables tblindividualdetails and daybyday do not contain fields on which i can create a relationship between the two. Therefore the difficulty in creating a report or a query using the two tables.
 
both databases will need some kind of information that is the same in both
databases so that some kind of relationship can be identified, so as to
display the information you want to display eg The residents DB should have
a residentID field. The events if related to a particular resident should
also have a residentID field then you can effectively link the 2 in a query
for your report.. That's it in a nutshell

breezereef



nathan said:
I have two databases - one details of residents and second details of
Click to expand...
events of the organisation. I want to generate a report that displays events
from both databases especially on the anniversary of an event (eg. DoB) of a
person or the organisation. How do I create a report that can use both the
databases?
 
Hi Breeze
Your reply if true would make me sad and blue. I from a foxpro background shifting to Access am finding it difficult to cope with the situation that I cannot display info from two unrelated tables. Please help
The two tables cannot be related. One is information of events related to the organisation (eventId) - training programmes, visitors etc and the other information of the residents (resiId) - birthdays, day of death, date of admission etc. At the click of a button I would like to consolidate the information and display it datewise for a selected period or month (one report) and another report displaying anniversarys of events of the organisation or of individuals.
Could you help me. Thank
Natha


----- BreezeReef wrote: ----

both databases will need some kind of information that is the same in bot
databases so that some kind of relationship can be identified, so as t
display the information you want to display eg The residents DB should hav
a residentID field. The events if related to a particular resident shoul
also have a residentID field then you can effectively link the 2 in a quer
for your report.. That's it in a nutshel

breezeree



nathan said:
I have two databases - one details of residents and second details o
Click to expand...
events of the organisation. I want to generate a report that displays event
from both databases especially on the anniversary of an event (eg. DoB) of
person or the organisation. How do I create a report that can use both th
databases
 
Back
Top