Add New record through relationship
I have three related table in my database TABLE 1, TABLE 2 and TABLE 3. The main table (TABLE 1) is related to TABLE 2 by two fields, let's say A & B. TABLE 2 is related to TABLE 3 at field C. This is a one-to-many relationship where one record in TABLE 2 equals many from TABLE 3. Is there a way to add a new record in TABLE 2 automatically when a new record is added in TABLE 3? I have the relationship settings checked to allow this, but so far can't get it to happen. I'm wondering if it is because of the many in TABLE 3 to the one in TABLE 2. Can anybody help with this?