Many To Many Relationship - linker table not updating

[madrav72]

hi,

i have a many to many relationship setup

TABLE A
TABLE B
TABLE AB - LINKER

i have made a form via the wizard that displays table A stuff and then table B stuff in subform

however theres seems to be a problem as when i enter a record into the subform i.e. table B the linker table Ab is not being updated so when i close the form and go back to it the record in the subform disappears despite the fact that it does exist in the table.

 

[Ayat]

many to many relationship setup

Base your subform on the linker table (i.e. choose the two id fields of the other tables from the linker table). then create combo or whatever control you want and base it on (i.e. choose id and desc etc field) the other table (not one on which you created the main form). declare control source for this control to be the same id that appears in the drop down list of the control source line in the properties sheet.

this should do it