Home > Administrator Functions > Managing Tables > Defining Relationships > Add Relationship

Add Relationship

To build a new relationship between existing custom tables is easy.

1. Open Act!
2. Click on the Tools menu and select Define Custom Tables...
    
3. Click the Define Relationship link.
    
4. Click the Add Relationship link.
   
5. The Relationship Creation Wizard will appear.  Click Next to begin.
   
6. Select the Parent Table from the dropdown and the Child Table from the dropdown.  Click Next.
   
7. Assign a name to the newly created key which will link the two fields. This Child Table field will hold the special key linking the two tables. Click Next.
   
8. Select the field in the Parent table which will identify it from the Child table or create a brand new field.  Click Next.
   
9. Select the Screen used to edit the data.  Click Next.
   
10. Give the relationship a unique name. Click Next.
    
11. Click Finish to create the relationship.
    
12. Click OK to return to the Define Fields screen.

See also