Justicia constitucional (en caso que se aplicable)

As you make search selections, the set of matching records appears automatically in the Records pane. Selecting a record in the Records pane displays its data in the Record Detail tab, where you can edit it.

The following sections describe how to edit the various field and attribute types available with MDM.

Hint: You can use role-based privileges to decide whether users must check out records before editing them.

Keyboard Shortcuts for Record Editing

Since it is common to edit a series of adjacent records in the Records pane, and even to edit the same fields in each record, the MDM Data Manager provides several time-saving keystroke combinations that speed up editing under these circumstances.

Keyboard Shortcuts for Record Editing Keystroke Command Description Shift+Ctrl+Up Previous

Record

Saves the current record and moves to the previous record while remaining on the same cell in the Record Detail tab.

Shift+Ctrl+Down Next Record Saves the current record and moves to the next record while remaining on the same cell in the Record Detail tab.

Ctrl+' “Ditto” Enters the value entered into the same field in the previously edited record.

F2 Edit Enters the field for editing, or opens the drop-down control for selection.

Shift+Enter Save Record Saves the changes made to the current record or group of records.

Esc Restore

Record

Discards changes and restores the previous field values. This must be done before changes have been saved.

Note: Each of the commands above works only when the focus is on a cell in the Record Detail tab.

Custom Data Entry and Editing Controls

MDM includes many enhancements to the normal Windows controls, as described in the sections that follow.

Note: The term cell is used to refer to the rectangular area in the row/column grid in the Record Detail tab, like the cell in a spreadsheet or a database table. Each cell contains a data value.

Hint: You can use Tab and Shift+Tab and the motion keys to move between cells in a grid.

Single-Valued Lookup Cells

Remember, MDM often enforces data integrity by creating a predefined set of lookup values, either as the records of a lookup subtable (where the value of a lookup field is restricted to the set of values of the subtable records), or as the set of values defined for a text attribute.

These lookup values are displayed in drop-down controls that contain the set of values that can be selected by the user:

• Drop-down list. For a single-valued lookup field into a flat table or a text attribute, the cell in the Record Detail tab is a drop-down control that contains a list.

Figure 40: Drop-down list control for flat table lookup or text attribute

• Drop-down tree. For a single-valued lookup field into a hierarchy table, the cell in the Record Detail tab is a drop-down control that contains a tree structure

Figure 41: Drop down list control for hierarchy lookup

Hint: You do not need to click on the “down triangle” in a dropdown list or tree control to open it. You can simply start typing once the drop-down control has the focus, and it will open automatically.

Hint: The type-ahead seek feature jumps to the next matching item in a list or tree. It even opens tree nodes that are closed; that is, MDM will expand branches to find nodes that are not visible.

Multi-Valued Lookup Cells

Sometimes a lookup field or text attribute allows you to select multiple items from the predefined set of lookup values. For such a multi-valued field or attribute, the cell in the Record Detail tab is a custom drop-down control for multiple-item selection:

• Drop-down list. For a multi-valued lookup field into a flat table or a text attribute, the drop-down control contains a pair of lists: the list of available items on the left and the list of selected items on the right

Figure 42: Dual-list drop-down control for multi-valued flat lookup

• Drop-down tree. Similarly, for a multi-valued lookup field into a hierarchy table, the drop-down control contains the tree of available items on the left and the list of selected items on the right. On either side, you can highlight one or more items, either adjacent or non-adjacent, and move them from one side to the other for selection or deselection.

Note: When you add a flat item to the list of selected items, it is removed from the list of available items. When you add a hierarchy item to the list of selected items, it remains in the tree of available items and is highlighted in bold. You can select and add only leaf-node values from the tree of available items.

Note: The dual-list drop-down control for multiple-item selection appears not only in the drop-down edit control for multi-valued text fields and attributes, but also in various dialogs where multiple items can be selected, such as the Fields, Modify Mask, Create Publication, and Export dialogs, and in the object selector dialogs for Data Group selection. Multiple values are separated in the cell in the Record Detail tab by semi-colons.

Figure 43: Multi-valued display

There are various ways to move items from one list to the other to select (or deselect) one or more items, and to reorder them within the lists:

• Buttons. Click the Add (or Remove) button to move highlighted items from the Available list to the Selected list (or from the Selected list back to the Available list), or use the All (or None) button to select or deselect all of the items.

• Double-click. Double-click an item to move it between lists (dual-list control only).

• Drag-and-drop. Drag-and-drop one or more items to move them from one list to the other (dual-list control only).

• Reorder. To reorder items in the selected list, highlight one or more items (adjacent or non-adjacent), then drag-and-drop them as a group anywhere within the list to move them before the list item onto which you drop them.

Qualified Lookup Cells

You can link one or more qualified table records to a qualified lookup field by double-clicking on the cell in the Record Detail tab to open the qualified lookup selector dialog.

Figure 44: Qualified Lookup Cell

Note: Unlike other types of lookup tables, which typically use just a single display field for the lookup field value, each qualified table record will usually have multiple display fields, which can include any of the fields of the qualified table itself, as well as any of the qualifiers.

Note: Each qualified lookup value is the concatenation of the values of the multiple display fields and qualifiers, separated by vertical bars (|).This concatenated value is displayed as the value of the qualified table record in the qualified lookup cell and also in the qualified lookup search tab.

Note: Directly underneath the name of the qualified lookup field, MDM displays “[m of n]” (where ‘n’ is the total number of qualified table records linked to the current main table record and ‘m’ is number of those n records that match the current search selections for the qualified lookup field). The two numbers will be the same if: (1) the Filter checkbox is not currently checked; or (2) there are no search selections currently in effect for the qualified lookup field.

Measurement Cells

MDM allows you to associate a physical dimension with a measurement field or numeric attribute, and then to assign to every numeric value a unit of measure chosen from the list of units applicable to that dimension. For such a field or attribute, the cell in the Record Detail tab has two parts that are edited separately.

Figure 45: Measurement Cells

The left part contains the numeric value and accepts typed numeric data entry.

The right part contains the associated unit of measure (such as horsepower or

applicable to the particular physical dimension. You can use Tab and Shift+Tab and the left and right arrow keys to move between the two parts of a measurement cell.

Hint: Measurement cells make it easy to enforce data integrity, since units of measure must be selected from a predefined list of units rather than typed in by the user as a text string.

Multi-Valued Numeric and Measurement Cells

Sometimes a measurement field or numeric attribute allows you to enter multiple numeric values, with or without associated units of measure:

• Multi-valued numeric cells. For a multi-valued measurement field or numeric attribute without an associated physical dimension, the cell in the Record Detail tab is a custom drop-down control that contains a grid with a single column of numeric values.

Figure 46: Multi-valued Numeric Cells.

• Multi-valued measurement cells. For a multi-valued measurement field or numeric attribute with an associated physical dimension, the cell in the Record Detail tab is a custom drop-down control that contains a two-column grid with a row for each measurement value.

In either case, you can enter, edit, and reorder values as follows:

• Add numeric value. To add a numeric value, type the numeric value in the first empty row and press Return, or press Tab to enter the value and move to the next empty row.

• Add measurement value. To add a measurement value, type the numeric value in the left part of the first empty row, press Tab, select a unit of measure from the drop down, and press Tab to move to the next empty row.

• Delete value. To delete a value, move the thick bordered highlight to the row containing the value you want to delete and press Del.

• Reorder values. To reorder the numeric values, press Ctrl+Up and Ctrl+Down to move the current row up and down.

Note: Multiple values are separated in the cell by semi-colons.

Coupled Numeric Measurement Cells

MDM includes a unique coupled numeric data type for attributes that allows you to store coupled pairs of measurement values. Each member of the pair can have a different physical dimension, allowing you to store the technical specifications of a product that are defined along a continuum. For example, the horsepower rating of a motor might be:

• 5 hp @ 3500 rpm

• 6 hp @ 4500 rpm

• 7 hp @ 5500 rpm

For coupled numeric attributes, the cell in the Record Detail tab is a custom control that contains a four-column grid with a row for each pair of coupled measurement values.

Figure 47: Maintaining Coupled Numeric Cells

Entering, editing, and reordering values in a coupled numeric drop-down control is identical to a multi-valued measurement cell, except you must enter two measurement values for each grid row rather than just one.

Note: A coupled numeric attribute appears as “name delimiter coupledname” (where “delimiter” is the user-defined, attribute-specific delimiter string for the attribute – in the example above, name is voltage input, delimiter is @ and coupled name is phase).

Note: Just as with a measurement field or numeric attribute, either or both coupled dimensions may not have an associated physical dimension, in which case the corresponding column in the drop-down control contains numeric rather than measurement cells. Multiple value pairs are separated by semi-colons.

Large Text Cells

You can type a string of text of unlimited length directly into a large text field. In the Record Detail tab, large text fields are multi-line edit cells.

Note: A large text field is like a text block field except that it is not stored in a separate table. This is useful when you know that a text field value will never be shared by multiple records.

Hint: Since Tab (which normally moves from cell to cell in the Record Detail tab) inserts a tab into the text in a large text cell, press Ctrl+Tab to move to the next cell. Similarly, since Enter (which normally ends an edit and closes a cell) inserts a new line into the text in a large text cell, press Ctrl+Enter to end the edit and close the cell. To change the row height of the cell, drag the row splitter up or down.

Image Lookup Cells

You can link one or more images to an image lookup field by double-clicking on the cell in the Record Detail tab to open the image selector dialog

Figure 48: Image Lookup Cells

Hint: To change the row height of the cell, drag the row splitter up or down. As you change the row height, the thumbnail of each image is automatically resized to fit vertically in the cell.

Hint: You can also right-click on the image field and, without even entering the image selector dialog, choose from the context menu to perform various functions, some of which cannot be performed from the main menu.

Text Block (and Copy Block / Text HTML) Lookup Cells

Text blocks differ from large text in that text blocks, like images, are stored in an object lookup subtable for linking to fields in one or more records in the main table or another subtable, while the text in a large text field is entered directly into the record of the table itself. Text blocks are useful when several records may share the same textual information. You can link one or more text blocks to a text block lookup field by double-clicking on the cell in the Record Detail tab to open the text block selector dialog.

Figure 49: Text Block Lookup Cells

Hint: To change the row height of the cell, drag the row splitter up or down. This adjustment is independent of the slider control; making the row taller does not display more lines than indicated by the slider control.

Finally, use the vertical scroll bar on the right of the cell to move through the list of linked text blocks.

Hint: You can also right-click on the text block field and, without even entering the text block selector dialog, choose from the context menu to perform various functions, some of which cannot be performed from the main menu.

Note: MDM also supports copy blocks and HTML text blocks, which you can link to a copy block or text HTML lookup field the same way you link text blocks to a text block lookup field.

PDF Lookup Cells

You can link one or more PDFs to a PDF lookup field by double-clicking on the cell in the Record Detail tab to open the PDF selector dialog.

Hint: You can also right-click on the PDF field and, without even entering the PDF selector dialog, choose from the context menu to perform various functions, some of which cannot be performed from the main menu.

Relationships Cell

For each product-level relationship, you can link one or more records to the current record by double-clicking on the cell in the Record Detail tab to open the Relationships pop-up window.

Figure 50: Relationships Cell

Note: A single Relationships cell for all relationships appears as the first cell on the right side of the Record Detail tab if you have one or more product-level relationships defined for the current table.

Masks Cell

The Masks cell displays a list of masks to which the selected record belongs, one name per line (using the unique node name syntax). You cannot edit the Masks cell.

Figure 51: Masks Cell

Note: For a multi-valued field/attribute with multiple record selection, MDM separate each set of multiple values with a dotted line.