Allocation database

[mambo21]

Hello,

I am trying to design a database that would allocate projects to volunteers automatically. I am a Nervous programmer on Ms Access and VBA, so any help would be appreciated.

Here is how i hope the system should be able to do, I have created all the necessary tables, queries and a form. They are on the attachement below

1.Run the qryImport1 to import all the first choices to tblTemp_choices(Volunt_Id, Project_Id)
2.Take Volunt_Id and Project_Id from the first volunteer
3. Check if the project is allocated from tblProject.Allocated
4.If allocated column in tblProject is Yes then delete the student from tblTemp_Choice
5.If Allocated column in tblProject is No go to tblCoordinator to check if Remain_Places is 0
6.If Remain_Places is 0 then delete the student from tblTemp_Choice
7.If Remain_Places is not 0 decrement the value on the column by 1
8. Then go back to tblProject and change Allocated column to Yes
9. The repeate steps 2 to 8 for the second volunteer untill the last volunteer
10. Match the Volunt_Id from tblTemp_Choices with Volunt_Id in tblChoice then change Allocated tblChoice to Yes
11.Insert the results from tblTemp_Choices into tblAllocated_Projects
12. Clear tblTemp_Choice
13. Repeate processes 1 by running qryImport2 upto process 12.
14. Repeate processes 1 by running qryImport3 upto process 12.

All this should be done by a click of a button on frmAllocation behind the scenes.

Thanks in Advance

Cheers