Add a Join Page
Last updated 10/04/2024
To add a Join page type you will need to have a many-to-many relationship in your database. A many-to-many relationship occurs when multiple records in a table are associated with multiple records in another table. For example, a many-to-many relationship exists between Employee and Department: employees can work in various departments, and departments can have many employees.
A third table is required to resolve this many-to-many relationship. This acts as a middle table. The original many-to-many relationship effectively becomes two one-to-many relationships. The unique identifier (Primary Key) of the Employee and the Department tables are taken on by the middle table as foreign keys. This is represented in the diagram below.
For this example, we will create an Employees form that has a Departments join page to enable us to assign departments to an employee.
Add a Join Page Type
Add Form One (Departments)
1. Select Visual in the menu and Form Wizard in the sub-menu.
2. Select your data source (Department) in the Main Data Source field.
3. Click the Next button.
4. Perform any changes required for your form fields and click the Save button in the Form Wizard app bar.
Add Form Two (Employees)
1. Select your data source (Employee) in the Main Data Source field.
2. Click the Next button.
3. Perform any changes required for your form fields and click the Save button in the Form Wizard app bar.
Add Form Three (EmployeeDepartments)
1. Select your join table as the data source in the Main Data Source field.
2. Click the menu item switch off.
3. Click the Next button.
4. Ensure that the Req. and List checkboxes are clicked for both of the foreign key fields.
5. Click the Save button in the Form Wizard app bar.