Hi, I have reviewed your database and see that you have thought through many issues.
1) I suggest that you use the Autonumber field in tblProjects as the unique number for each
project. Access will manage it, keep it unique (never duplicate it)
2) Use the same field name (ProjID) in the tblProjectDetails; however the field will be Number, Long Integer
more later
John