In Access I had designed a form (projects) with a subform (people). The subform would allow you to add existing people or enter a new person. When I converted the application to SQL Server backend, I could no longer add new people on the subform only add existing people.
Because projects can have many people and people can be on many projects there is a junction table
Why would SQL Serve database now not allow me to add new people on a subform when Access would?