I am developing a contacts database and need to have a method of inviting people to events.
I have a 2 tables
and have made a many to many relationship between them by creating a new table
I have a main form
'person details' whose record source is persontbl
and then a subform within the main form called events whose record source is event_person junctiontbl where the events are listed and there are yes/no tick boxes to invite. This works well with the existing records, however, when i add a new person on the main form the junction table does not add events records and therefore the subform doesn't work
How do i get round this? Have i done this in the best way to start with?
All help gratefully received