I started out with a multi-table query, which I have simplified down to 2 tables. The form team members works great to select the team leader and display the team, but I can't add team members or edit team members or delete team members.
I realize I need a totally different approach, but don't know where to start, since these two tables are necessary. If you could tell me what I need to do, I would greatly appreciate it.
Relevant tables are
Congregations
Individuals
Teams
Ind_roles
Teams are made up of individuals in a congregation. They have different roles, statuses, begin and end dates.
Thank you for your help! Database attached.test.zip