Duplicate records showing on form when data added to subform

[wombatsam]

Hello,



Is anyone able to help me with my database? I have a problem where when I add a person (on a subform), to a company (on the main form), my form displays as many records for the company as there are people. No records get added to the company table, it's just the form they show on. I have two subforms on the main form. I think it's a join problem, but can't figure it out.

I am attaching the database, (apologies for its low quality, rusty mum returning to the workforce!)

Thanks
Sam

ContactDatabase27April2012.zip

[June7]

Main form should not include Person table in its RecordSource.

[wombatsam]

Thank you so much! Access automatically built that query when I started creating the form, so I didn't think it would be wrong. Thanks again, much appreciated :-)