Auto-Create records in related tables
I'm working on a database that will allow me to keep track of employees and their skill sets.
I've created tables that contain different information about an employee. Each table is related by a key that is automatically created in the parent table.
I'm trying to program the database to auto-create records in the related tables when a record is created in the parent table.
I've edited the relationships between each table and checked off: "Allow creation of records in this table via this relationsip" and "Delete related records in this table when a record is deleted in the other table" under the "child" tables.
However, everytime I create a new record in the parent table, the child tables don't automatically create records with the same ID number that each table is related by.
Can anyone help me with this problem?