OK, I have done some work on your database in line with my comments/questions.
I have modified the Functions form and table to include the Posid and added the Position to the Functions form.
I have modified the requirements form and it's code so that it updates both itself and the functions form.
The Requirements form will ask if you are sure you want to delete a date, if you say no it will put back the original date.
If you say yes it will remove the date on that form and if it is also on the functions form if it matches along with the PosID.
The functions PosID and the date are only updated when all the requirements have been met for that function.
At the moment I have only created the code to update the PosID for Functions 1 & 2, if you want to go with this design then I or you can create the rest.
Let me know what you think.
Reply With Quote