Junction forms confusion

[ZOR]

I have a mainform, which has a subform on it bound to a Junction Table. It is related/linked with the mainforms primary key. On the Junction form there is another subform bound to a names table. The Names form is related/linked to the Junction form primary key.

When I cycle the mainforms records (navigation buttons), the Junction form cycles its records, and in turn the Names form cycles its records. However if I try to add a new record in the Names form, the related field AthleteID value in the Junction table is 0, but the AthleteID field in the Names form (Primary Key) gets it's value entered.

I think I might be twisting it all around, as the Junction/Names are in a many to many situation, and I think my subforms are behaving in a one to many.

Any ideas where I am going wrong? Thanks

 

[fneily]

Need more info. Please post your table names, fields in each table. Did you normalized the tables? Seems something is wrong if your junction table is in a many-to-many relationship with your names table. This means you need another junction table. But don't do that. Let's see your tables and fields first.