Record creation via relationship not working
I have a join table between an "events" table and a "contacts" table so that I can have multiple contacts be included in multiple events (many-to-many relationship). In both cases the relationship between the parent table and the join table allow for creation and deletion of records in the join table via the relationship to the parent table. However, a new record IS NOT created in the join table when a new record is created in the "events" table; I have to manually add a record in the join table. But when a new record is created in "contacts," a new record IS created in the join table.
I have created a test DB to see if there was something apparent that I was doing wrong, but in the test DB, everything seemed to work fine.
Thanks for any light you can shed!
FMPro 11.0v4, Mac OSX 10.7.5