i am trying to create a new relationship data base for my job. I have 4 tables so far, Employee records, Payroll, Contract and Confirmed event.
Both the employees table and the payroll table are linked with each and they are working properly. if i create a new employee record a new record is also created on the payroll table with the same employee ID number. I wanted to recreate that same with Contracts and Confirmed events. how ever; when i create a new contract it does not create a new record on confirmed events. but if create a new record on confirmed events and add the address or any information it does create a new record on the contract's table. i tried to move the relation ship around but it has the same output. what am i doing wrong?