Selecting a value in a subform adds a new record to its table?

[DBLoser]

I have built a many-to-many relationship via two one-to-many relationships.

Table: tblDR
Pkey: DRNum

Table: tblDRPerson
Fkey: DRNum
Fkey: GroupID

Table: tblGroup
Pkey: GroupID
Field: GroupName

I have a form called formDR with a subform called “Groups subform”.

I can select a group via the GroupName combobox in the Group subform but when I do, instead of just selecting a group from tblGroup, it adds a new group every time I select it. For example, if I select Engineering (group 1) three times, it adds Engineering three more times to tblGroup. How can I fix it to just select a group from the list?

 

[lameid]

Sounds like you intended to create a subform based on a record source using tblDRPerson and instead based the record source on tblGroup (or you just used the wrong form as a subform).