I'm creating a database to manage members of a University student organization.

I built a People table and a Members table since not all people that attend meetings are members of the org.

I created the People form and inserted the members form as a subform.

With the example I have below, I have John Smith as a person and he's a member but how do I include his name into the subform without having to duplicate work when I first enter his information into the form? This is an issue because if I only want to look at the members list, only the information in the subform appears.

Thanks!