{Header}
This example shows how to implement a sample record form based on a table that uses a multi-column primary key.
To assign projects to an existing employee, select a project from the list to the left then specify the project and the employee and enter a percentage allocation value. Click Submit when finished.
To create a new record, click Add New, select the Project and Employee, enter the Percentage allocation value then click the Add Button.
Database: Intranet
Tables: projects, employees, projects_employees
The Record form’s OnValidate event is used to make sure that an employee is not assigned to the same project twice.
The OnValidate event of the Percent_allocation Text Box is used to ensure that the value entered in not greater than 100.