Hello Experts,
I have an urging issue that I desperately need to solve.
I’ll just explain the rational of my database before presenting the issue:
I have a projects Database with: Projects_Table, Staff_Table
Both tables has forms for data entry or update. Each project has many staff allocated to it.
In the Staff_Form I placed the “Project_Code” in the form heading section. The form opens based on a search criterion on the project_code so it shows the staff for that project only.
The issue is when I try to add a new staff for that project on the Staff_Form, the project_code stays blank in the staff_table. What I need is that the project_code in the staff_table for that newly added person to have the same project_code on the opened form. Simply to link the staff to the project they work in when I add them using the form.
How can I achieve that????
I have an urging issue that I desperately need to solve.
I’ll just explain the rational of my database before presenting the issue:
I have a projects Database with: Projects_Table, Staff_Table
Both tables has forms for data entry or update. Each project has many staff allocated to it.
In the Staff_Form I placed the “Project_Code” in the form heading section. The form opens based on a search criterion on the project_code so it shows the staff for that project only.
The issue is when I try to add a new staff for that project on the Staff_Form, the project_code stays blank in the staff_table. What I need is that the project_code in the staff_table for that newly added person to have the same project_code on the opened form. Simply to link the staff to the project they work in when I add them using the form.
How can I achieve that????