How to save form data in Microsoft Access?

Question

Database

There are 3 tables

Groups, students, prefects. It is necessary to make a form for adding a group with the ability to select/change the headman
Created a form, added a list to it:

The list takes data from the request

SELECT students.id, students.lastname, students.firstname, students.patronymic FROM students WHERE (((students.group_id)=Forms![groups]![id]));

How to keep the elder? How to implement post editing?

Answer 1

Create a data source for the form, a query. Everything will be saved by itself when you move to the next record. We need a group and a leader in it.