Integrate data from two databases

[ReportDr00]

Hello

I need some guidance on below scenario on how to approach it

I have a report from database A that gives me displays
ClientID, Service ID and Service Name and Service Date

but i would like to replace the service id on the above report with service id from table in database B.

database b is in access and the table in database A and B has one common field i.e service name but their service id's are different and i want to have service id of database b to be displayed on the report.

Any ideas on accomplishing this ?

Armani

 

[lbass]

If you link the tables on the name field, you should be able to place the database b service ID on the report, add the other fields from database a, and then go to database->select distinct records.

If this doesn't work, please show a sample of the results you get when you try this.

-LB

 

[ReportDr00]

why do you suggest to select distinct records, it is possible that a client could receive same service more than one time on different days, if i select distinct records then will it not give me only one record for service name per client?

 

[lbass]

No, it wouldn't--a second date would force another record (or two). I think if you placed the four fields on the report that the two tables would result in two records--one per service ID (even though you are placing only one on the report) unless you use select distinct. But why not just try it and see? I can't really mock this up to see exactly how to approach it, but you could try and then report back if it doesn't work.

-LB