Duplication in Queries

[Justin]

I have searched the forum but cannot find an answer to this problem so I hope someone can help me. I have a multiple table database and I have set up a search form so that for example to search for an entry by name, you choose the name from a combo box (picked up from the INDIVIDUAL table) and then click a button to bring up a data entry form that displays all data from all tables for that person. However, if a person has more than one corresponding linked entry in anothet table, the information will be displayed that many times. Example, if a person has 3 donations specified in the DONATIONS table, when you search for their name, the form displays 3 records even though they are exactly the same person and exactly the same information every time; if they have 4 donations, 4 records are displayed. Can someone explain how i can resolve this so the persons data is only displayed once? thanks

 

[ColinEssex]

I think what you need is to display the donations data in a subform. Have the persons demograhic data come up as the main form. If you use a subform for donations data, that can then be displayed as a list.

Col

 

[Justin]

Thanks - sorry I should have said that I already have Donations displayed on the form as a subform and even though the number of entries are displayed in this subform, I still get the same number of records duplicated ???

 

[ColinEssex]

Post a copy of the Db. I'll have a butchers at it for you.

Col

 

[Justin]

Thanks for that but I can't seem to upload the database as its too big and I have tried compressing it too and its still 500k too big.....i have added a couple of JPEGS if thats any help. Notice that there are 3 donation entries for the person and 3 records have been returned even though they are all the same