Show List and Detail

media_1486614833512.png

You have the option of showing a list and detail side by side.

media_1486614865173.png

Select the Form you would like to apply the Show List and Detail option.

media_1486614910375.png

Select the Options dropdown and click the Show List and Detail item to turn on and off this option.

Note: when first running your program you may have to click on the form and off to make the visual changes permanent.

Browsers

Adding a Browser Item

media_1450336018305.png

Select the Form the Browser Item will be added.

media_1450345585650.png

Under the Forms section, click the Browser button.

media_1450336025347.png

To add a new Browser, click the Add button.

media_1450340470812.png

Type in the Url that will be displayed and click Ok.

media_1450341004382.png

Navigate to the correct Form Detail View.

media_1450341013573.png

Right click anywhere, on the Form, and click the Customize Layout option.

media_1450341049547.png

The new Browser Item will be under Hidden Items.

Drag and drop the Browser Item onto the Form.

media_1450341070090.png

Removing a Browser Item

media_1450341170963.png

Select the Browser Item to be removed and click the Remove button.

media_1450341180320.png

Confirm the deletion by clicking OK.

Banner Item

media_1450335483485.png

Select the form the Banner Item will be added

media_1450345597937.png

Under the Forms section, click the Banner button.

media_1450335498969.png

To add a new Banner Item, click the Add button.

media_1450335508592.png

Double click to load the image, add in the Url and click Ok.

media_1450335560654.png

media_1450335616273.png

Run the program and navigate to the correct Form Detail View.

media_1450335623564.png

Right click anywhere on the form and click the Customize Layout option.

media_1450335693875.png

The Banner Item will be listed under Hidden Items.

Drag and drop the Banner Item onto the Form.

media_1450335720316.png

Removing a Banner Item

media_1450335981390.png

Selec the correct row to remove and click the Remove button.

media_1450335992798.png

Confirm deletion by clicking OK.

Hyperlink Item

Adding a Hyperlink Item

media_1450316864647.png

Select the form the Hyperlink Item will be added.

media_1450345606368.png

Under the Forms section, click the Hyperlinks button.

media_1450316879592.png

To add a hyperlink, click the Add button.

media_1450327770389.png

Type in the Caption, Url and click Ok.

media_1450327792840.png

media_1450332904985.png

Run the program and navigate to the form’s Detail View the Hyperlink item was added.

media_1450332912849.png

Right click on the form and select the Customize Layout option.

media_1450332975091.png

The Hyperlink Item will be listed in the Hidden Items.

Drag the Hyperlink onto the form.

media_1450332993390.png

Removing a Hyperlink Item

media_1450334847882.png

Select the Hyperlink Item to be remove and click the Remove button

media_1450334866903.png

Confirm the deletion by clicking OK.

Text Item

Adding a Text Item.

media_1450314972247.png

Select the form the Text item will be added.

media_1450345614824.png

Under the Forms section, click the Text option.

media_1450314992378.png

To add a form, click the Add button.

media_1450315013298.png

Type in the text you would like to display including any styling.

Please note: you can also open up a document file by choosing File, then Open.

media_1450315246706.png

Close out of the window be clicking he Close button.

media_1450315681273.png

Run your program, navigate to the Detail View of the form that the Text item was added.

media_1450315688351.png

Right click anywhere, on the form, and click the Customize Layout option.

media_1450315698605.png

The Text item should be shown under Hidden Items.

Drag and drop the Text item onto the form.

media_1450315761751.png

Removing a Text Item.

media_1450334933171.png

Select the row to be removed and click the Remove button.

media_1450334942946.png

Confirm the deletion by clicking OK.

Static Items Overview

media_1448033221396.png

Static items are items that will be shown on each record for a particular form.

Text Items – displays rich text.
Hyperlinks – displays clickeable links.
Banner – displays clickeable images.
Browsers – displays specific website urls.

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.