Many to Many Relationship

media_1448466795504.png

Click the Many to Many button in the Relationships section.

media_1448466790823.png

Click on the Parent of the Relationship.

media_1448466811916.png

While holding the mouse button down, drag to the Child and release the mouse button.

media_1448468078687.png

In a Many to Many relationship, both Parent and Child will allow the user to add many records.

media_1448468133389.png

One to Many Relationship

media_1448466749086.png

Click the One To Many button in the Relationships section.

media_1448466743018.png

Select the Parent (Form) of the Relationship.

media_1448466772244.png

While holding the mouse down, drag to the Form that will represent the Child.

media_1448467910318.png

The Parent will include a Grid that will allow you to add Many different Children.

media_1448467892698.png

The Child will have a Property Editor that will allow you to add only one Parent.

One to One Relationship

media_1448466140063.png

Click the One to One button in the Relationships section.

media_1448466133399.png

Click on the Form that will start the Relationship.

media_1448466157664.png

While holding the mouse down, drag the cursor over the Form that will be part of the Relationship.

media_1448467740031.png

The first Form that was selected will be considered the Parent.

media_1448467816105.png

The last Form added will be considered the Child.

What are Relationships?

A Relationship allows Forms to have relationships with other Forms.

For example: A person places an order. The customer service rep can look at the Person’s record and view all orders that Person has placed.

There are three types of relationships you can use.

One to One
An example of a One to One relationship would be a Person would have one License. A License would be assigned to only one Person

One To Many
An example of a One to Many relationship would be a Person would place many Orders throughout their lifetime. An Order would have been placed by only one Person.

Many to Many
An examply of a Many to Many relationship would be one Order containing many Products. A Product would be added to many different Orders.