<< Click to Display Table of Contents >> RayPack > 8.0 > User Guide > PackDesigner > MSI / MST / RPP Based Projects > Advanced Mode > Tables > Advanced Editor Interface Features  Reference Integrity Tracking

Since Windows Installer technology is based on the concept of relational database structures, there are tables that do not only contain primary keys, but also foreign keys, which establish object relations to the content of other database tables.

 

Whenever RayPack recognizes such a relation between table columns, it adjusts the direct inline edit mode of the affected cells: Users may keep on manually typing any value they see fit. But in order to keep an eye on the referential integrity of the Installer database, it is recommended to use one of the values offered by the drop-down selector control that is automatically added to cells that require it.

 

When users edit cells that offer a list of preselected values, a downwards arrow on the right-hand side of the cell indicates the availability of an additional editor control. Clicking it reveals a list of possible values for the currently edited column. If the given cell value exists as item within this option list, a blue background color marker is used to indicate its selected state. Picking any of the options from the list replaces the old cell content with this new value.

 

Making use of the reference integrity features of RayPack has additional benefits: Whenever a referenced value is updated within the original database table, all references are updated automatically. Issues regarding inconsistent key relations are therefore a burden of the past.

 

The list of cell references (including also formatted string references among others) is shown below the table view. For more information, refer to the section Row tracking.