Clarion Community Help

This Control template is dependent upon the existence of the MultiChildRelationTree control template, and adds three buttons (Insert, Change, and Delete) which allow the user to call the associated update procedure for the selected level of the relation tree (if an update procedure has been specified) . The Change and Delete buttons correspond to the currently highlighted record. The Insert button adds the target child record (the next level down the tree structure).

The following template prompts are available:

General Tab

The options in the General tab target the relation tree's popup options.

Use Update via Popup

Check this box to allow update actions (Insert, Change, Delete) to be called from a popup menu

Add Separation

Check this box to also include a separator in the popup menu after these update items

Use Button Text for Popup (Text)

Check this box to automatically assign the update button text to the popup menu item. If you turn this option off, the default text of the popup menu (Insert', Change', Delete) will be used.

Use Alternative Update (Key)

If you would like to assign an alternate key to call the popup menu, check this box, and designate an Activation Key. You can use the ellipsis button to access the Select Key dialog to assist you.

Use Help Tool tip

Check this box if you would like to use the help tool tip of each update button as a tool tip for the popup menu.

Popup Priority

Enter a number here that will set the order that the update items will appear on the popup menu. A smaller number will bring the items to the top of the popup menu.

Primary Level

The options in the Primary Level tab target the optional Update Procedure used for the relation tree's primary table.

Update Procedure

Select the update procedure to call for the primary file. You can enter a new one, or select from the drop list. The procedure selected may be accessed with the RIGHT-CLICK popup menu when enabled automatically provided when you specify an update procedure. The default popup menu text is “Insert',” “Change',” and “Delete.” If your update procedure has parameters, you can specify them in the Call with parameters option.

Finally, optionally check the Allow Insert, Allow Change, Allow Delete, or Allow View check boxes to enable the appropriate action.

Child Levels

The list box in the Child Levels tab displays all child tables used in the relation tree. If an update procedure is designated for a child table, the list box item will show “Edit <;Child Table> with <;update procedure>”. If am update procedure is not designated, the list box item will show “<;child table> not edited” instead. Press the Properties button to access the Secondary Level dialog and the following options:

Update Procedure

Select the update procedure to call for the selected child table. You can enter a new one, or select from the drop list. The procedure selected may be accessed with the RIGHT-CLICK popup menu when enabled automatically provided when you specify an update procedure. The default popup menu text is “Insert',” “Change',” and “Delete.” If your update procedure has parameters, you can specify them in the Call with parameters option. An optional description can be added here, which is only used for developer documentation (it is not generated in source).

Finally, optionally check the Allow Insert, Allow Change, Allow Delete, or Allow View check boxes to enable the appropriate action.

Allow MANY:1 Child Autoinc

Whenever you insert a child record check this box to enable the MultiChildRelationTree to prime the lookup file before calling the child update form. The default is OFF.