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.