Recommended video: Creating Relationships
Click "Database" from main menu, click "Catalogs".
Select the catalog you wish to create a new relationship for, click "Fields" button.
A new window containing the field list for current catalog will be opened. Click "Create New" button.
Select "Relationship" from Data Type selection box,
Select N-N Relationship from Relationship Type selection box,
Select the target catalog you wish to create relationship from Relevant Catalog selection box,
Type a title into the both "List Title" boxes. (On record forms, a list of related records from target catalog will be listed under this title.)
Example: If you are creating a relationship for "Student" catalog and you selected "Teacher" catalog as target, you may use a title like "Related Teachers" and "Related Students" respectively. So you may access all the related teachers of a student record by clicking a menu button. The same is true for a teacher record.
Note that you could do the same thing in the oppposite way by creating a N to N Relationship for "Teacher" catalog with selecting "Student" catalog as target. The end result would be exactly the same.
Example: If you have created a relationship for "Student" catalog and you selected "Teacher" catalog as target,
create a side menu button for "Student" catalog. Open catalogs window, select "Student" catalog,
click "Form Menus" button, intall the menu item for the new field.
Repeat the same process for the "Teacher" catalog.
See Creating Form Menus for more info.
Changing field titles and lookup fields are allowed. You may safely modify them whenever you wish.
See Erasing Fields for information about how to delete a field.