Extracurricular Subject

This form is used to manage extracurricular subject data.

Database table: schoolextralesson
Primary Key: id (Code).
User permissions: Access for this form (create, update, delete, duplicate) can be configured from the General → User Role List menu.
Initial focus when creating data: Field Code will receive focus first.
Sorting order: Records are sorted by Code.
List print template: Adjust the list print layout via General → Print Layout using Design Group = .

Additional Fields

The additional fields section contains several inputs that end users can populate:

Name
The name input is required.. The name input can be used as a filter on the main list form..
Teacher
The teacher input is required.. The teacher input can be used as a filter on the main list form..
- Options are loaded from table schoolteacher (form Teacher). The default value follows the Role User form, but you can choose another item.
Student in Extracurricular
- Add Student in Extracurricular entries via the [+ New] action (or [+] icon on mobile). The dialog that appears contains the fields described in Student in Extracurricular.
Created By
This input is read-only and only displays data from system.. The created by input can be used as a filter on the main list form..
- This field shows the user code that created the record and is filled automatically.
Modified By
This input is read-only and only displays data from system.. The modified by input can be used as a filter on the main list form..
- This field shows the user code that last modified the record and is filled automatically.
Last Modified
This input is read-only and only displays data from system.. The last modified input can be used as a filter on the main list form..
- This field displays a timestamp that is populated automatically.

This form is used to manage student in extracurricular data.

Database table: schoolextralessonstudent
Primary Key: id (Code).
User permissions: Access for this form (create, update, delete, duplicate) can be configured from the General → User Role List menu.
Initial focus when creating data: Field Student ID Number will receive focus first.
Sorting order: Records are sorted by Code.
List print template: Adjust the list print layout via General → Print Layout using Design Group = .

The additional fields section contains several inputs that end users can populate:

Student ID Number
The student id number input is required.. The student id number input can be used as a filter on the main list form..
- This field searches table schoolstudent (form Student). Open the dropdown, type a keyword, and pick the desired record.
Student
This input is read-only and only displays data from system..
Created By
This input is read-only and only displays data from system.. The created by input can be used as a filter on the main list form..
- This field shows the user code that created the record and is filled automatically.
Modified By
This input is read-only and only displays data from system.. The modified by input can be used as a filter on the main list form..
- This field shows the user code that last modified the record and is filled automatically.
Last Modified
This input is read-only and only displays data from system.. The last modified input can be used as a filter on the main list form..
- This field displays a timestamp that is populated automatically.