Error "you cannot add or change a record because a related record is required in table exp_main"
I am getting the above error message on my database:
You cannot add or change a record because a related record is required in table 'exp_main''
I have a table called exp_mian and a various other table called employee_cost_details, project_cost_details etc which are linked with exp_main. One exp_main(exp_id) record will be linked to the previously mentioned tables record. However, one employee_cost_details table record will be linked to exactly one exp_main record. I also have a main form for the exp_main data that contains a subform for entering the details of the other tables data. When I try to add a new record to the employee_cost_details table, I get the above error message. Any ideas?
i will attach the sample relationships with the question.
kindly help me out with this problem.