By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,773 Members | 2,583 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,773 IT Pros & Developers. It's quick & easy.

Why does my query displays duplicate records?

P: 1
I have created two tables: One is called PARENT and the other CHILDREN. I have created a one to many relationship meaning one parent can have many children. When I create a query the parent name appears for reach child related to that particular parent.

Consequently, when I have three parent's records where they all have two children, the record count is 6 instead of 3

Please, Please, Please help.
Mar 21 '17 #1
Share this Question
Share on Google+
1 Reply


PhilOfWalton
Expert 100+
P: 1,430
That is correct. There are 6 children & they each have a parent.

Your mistake is looking at a query. You need a split personality to be an Access programmer. The Programmer is conscious of tables & queries, the User should only know about Forms & Reports.

You need to create a form for the parents and a continuous subform for the Children.

Incidentally, Parent is a reserved word in Access, so may I suggest you change your table names to TblParent & TblChildren.

Another Incidentally is that as many children have at least 2 parents (and step parents), you would get much more flexibility by having a join table to join parents and children with a combined key of ParentID & ChildID and possibly a date and relationship to indicate a new husband or wife had been added to the family.

Phil
Mar 21 '17 #2

Post your reply

Sign in to post your reply or Sign up for a free account.