In a many-to-many relation, one create joint table and use two columns of both ID's in a Composite way. This what the text books recommend.
I had a Form/subform to view the relation between the two table. I tried to add to the subform a new relation Access did not allow me to do it. I can go to the joint table in datasheet view and ADD to my heart content observing the unique condition.
If I change the design of the joint table to auto as PK and the two ID's with no PK in either, I can update from the subform ...
My question WHY the Composite Keys do not allow me to update the joint table by adding new records in the subform ???
I had a Form/subform to view the relation between the two table. I tried to add to the subform a new relation Access did not allow me to do it. I can go to the joint table in datasheet view and ADD to my heart content observing the unique condition.
If I change the design of the joint table to auto as PK and the two ID's with no PK in either, I can update from the subform ...
My question WHY the Composite Keys do not allow me to update the joint table by adding new records in the subform ???