M:M getting erroneous data

[Leventcos21]

Hi, I have form /subform that holds names for a field called process owner. Some records may have multiple Process Owners.

I noticed that when I scroll to the bottom of my combo there are numbers at the end, which I did not add.

tblNCR
NCRID (PK)

tblOwnerDet
NCRID (PK)
PROCID (PK)

tblProcOwner
ProcID(PK)
OwnerName

For example, If I select John Doe (1) on the list, When I go into tblOwnerDet there is a 21 for ProcID, rather than a 1

Why is this happening

 

[MajP]

tblOwnerDet
NCRID (FK)
PROCID (FK)

Make a composit index ont the two fields, but do not make them primary keys.

 

[MajP]

should read
Make a composite index on the two fields