Hi,
Shouldn't the payments relate to the tblProjectDetails instead of the tblProjects. This way you will allocate the payments to the specific part of the project that you want? We can always get the total for the project.
John
Shouldn't the payments relate to the tblProjectDetails instead of the tblProjects. This way you will allocate the payments to the specific part of the project that you want? We can always get the total for the project.
John
3) After we populate the field ProjID in the table tblProjectDetails with the corresponding number, we will not need the field ProjectName in the tblProjectDetails.
4) I have a couple of screen clips for you screen clips. Review my suggestion and the screen clips.
If I may be of further help, please let me know
John