ID certain tables by key fields/properties

[Uncle Gizmo]

Wouldn't you just use the main form? Instead of using it for Mr & Mrs Smith you would head it, 1) Setting up for basic alarm system, 2) setting up an advanced alarm system..... Etc

 

[AdamFeerst]

I would let them use the main form. They would enter both the client's name and the proj type. The Smiths might have multiple projects of the same or different type, either simultaneously or over time. The Jones, Glenns, etc., will have projects too. The SQL to insert the tasks into tblData would look something like:

"INSERT INTO tblData SELECT " & me.ProjID & " As ProjID, TaskID FROM tblList WHERE ProjType=" & me.cmbProjType
​