Insert a group of records.

[ep4tech]

Hi,
I have a student database contains the following tables:
Student Table (Id, StudentName, ClassNum, ....)
and action Table (Id, ActionDate, studentID,Status, reason, note)
Status fields possible values are: attended(=1) absent (=2), permitted(=3).
I want to build a form has the two unbound fields (Class Number and date) in the top of the form. a sub form should contain a grid (list) of all the students of that class number; each row of that grid consists of: Student name (non editable), status (drop-down list for example), reason (text box),)
The form should show all the class students.
When the user enters data (status, reason mad notes) the form should create a record in the action table With the student id, the date (entered in the top section) and the add data (i.e. status, reason mad notes)
How can i build a form contains records from a table (with records not exist before adding them).

Thanks in advance.

[pbaldy]

You can execute an append query that pulls the appropriate students from the student table and gets the date and class number from the form.

[ep4tech]

My question about the other
fields (status, reason and note) there should be a place (grid fro example) to enter them.

[pbaldy]

I would expect the subform to be bound to that table, enabling you to add that info.

[ep4tech]

If you are referring to the Student table, then student table doesn't contain the required fields (status , reason and note)
If you are referring to the action table, then action table doesn't contain any row bound to that date and class number. Hence, the form will contain no rows.

The form needs to show all the student names (from student table filtered by class num: the unbound control at the top of the form), date (from the unbound field top of the from) , the rest of the fields will be null values (i.e status , reason and note)
The records in action table will not be created until the data is entered and saved.

[pbaldy]

I was suggesting appending records to the action table at the start of this process, so it had records for each student for that date, allowing you to fill in the other fields.

[June7]

Cross-post https://stackoverflow.com/questions/...97354#52997354