I have a complex scenario I need help with. A member of my database is assigned to multiple user accounts each defined as a different role.
Supervisor
Leader
Overseer
The member is stored in 2 tables. One Member Information table and the other Group Information. For the Member Information I record all info like DOB, tel nr, email and the like as well as the connected Supervisor, Leader and Overseer for the member.
IN the Group Information table is the address of the group they belong to. The leader of the group and also the overseer of the group.
When a member joins the church I add them to the system and select who the leader assigned to them would be. I would then want to autopopulate all the remaining fields in member info table (Supervisor, Overseer and Group Name) with the information I have in a Structure table.
The member should then also be added to the Group INformation table under the name of the homecell group the leader they have been assigned to hosts.
Secondly
If a member moves groups. I need to be able to automate an update and change their Supervisor and Overseer information under the membership information table collectively as well as reflect in the new assigned group in the Group information Table.
I assumed Javascript is the only way but open to any suggestions.