Extracting common data from tables to view in a report

[kets]

Hi



I have a feedback database with 3 tables, one for complaints, compliments and other. They have the standard common fields such as name, address, date received, nature of enquiry, investigating officer etc etc.

A person can have more than one record in the complaints table and that same person could also have 1 one more records in the compliments and others table. What I would like to do is to be able to display the data for that same person that appears in the complaints, compliments and others table in a report using a search facility by either name or address. This will therefore display the number of times that this person has made contact together with dates and the reasons.

I would like to know how I can go about doing this and would be grateful for any assistance.

Regards

[pbaldy]

I would probably have a single table with a field for the type of feedback, but you can join your 3 tables together with a UNION query to be able to search and present combined results.