<div>
<div class="content wysiwyg-content">
In Access I had designed a form (projects) with a subform (people). &nbsp;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.<br />
<br />
Main Form<br />
Project ID<br />
Project Name<br />
<br />
People Subform<br />
People ID<br />
People Name<br />
<br />
Because projects can have many people and people can be on many projects there is a junction table<br />
<br />
ProjectID<br />
PeopleId<br />
PersonInvolvement<br />
<br />
Why would SQL Serve database now not allow me to add new people on a subform when Access would?<br />

</div>
</div>


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.

Main Form
Project ID
Project Name

People Subform
People ID
People Name

Because projects can have many people and people can be on many projects there is a junction table

ProjectID
PeopleId
PersonInvolvement

Why would SQL Serve database now not allow me to add new people on a subform when Access would?


Subform Restrictions

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.