dabug80
asked on
MS Access: Duplicate Records Showing in Subform
Hello,
I have a MS Access form, that has a subform. The bottom subform is showing duplicate record values and I can't figure out why. Attached is a screenshot and a sample database.
How do I restrict the subform to only showing each unique record once?
Thanks
Experts-Exchange-Questions.zip
I have a MS Access form, that has a subform. The bottom subform is showing duplicate record values and I can't figure out why. Attached is a screenshot and a sample database.
How do I restrict the subform to only showing each unique record once?
Thanks
Experts-Exchange-Questions.zip
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Generally, a main form/subform has the main form bound to the "one" table in a one-to-many relationship, and the subform bound to the "many" table. You may need to fix your table relationships so this will work (the sooner the better, as correct table structure and relationships are essential).
ASKER
Thanks. I see the problem now. I deleted the query fields from the unlinked table and it worked.