Many to Many relationship not working.

[jam]

Hi guys,

Got a problem with a many to many relationship. So much so I've started a new DB to test out whats wrong.

got a table called land
Got a table called owners
Got a junction table

Related them together using LandID and OwnerID via a many to many relationship using the junction table. The junction table contains LandID & OwnerID as numbers and primary key references.

Now when I create a form it gives me an error telling me that the field cannot be updated and the junction table has no data inside it and I loose the data.

Banging my head up against a brickwall!!!

 

[WIS]

Hi guys,
The junction table contains LandID & OwnerID as numbers and primary key references.

The junction tbl can't have PK's - it must have FK's. The PK's must be LandID & OwnerID in the other 2 tbls.

ie Land to Junction join 1 : many
Owner to junction join 1 : many