Configuring Table and Record Panels with the Configuration Wizard

Go to:

Page Layout Spreadsheet, Toolbox, Reports & Forms

Iron Speed Designer’s Configuration Wizard configures table and record panels in your application’s web pages.  The Configuration Wizard is automatically displayed when you drag a panel from the Toolbox onto your page.  It helps reduce the amount of page layout customization you do by hand.

Configure record and table panels with the Configuration Wizard.

Creating master-detail pages

Master-detail record-to-table relationships may be added to any Record or Table page that has a foreign key relationship with another database table, database view or query.  Iron Speed Designer uses these foreign key relationships to determine which tables can be included.  Moreover, your application will properly add the Master record into the database first, get its primary key (ID) and then store the ID in the Detail records associated with the Master record.

You can quickly and easily configure just about any page to be a “master-detail” page (also called “parent-child” or “one-to-many” pages) containing one or more related panels.  Simply drag a related table or record panel from the Toolbox onto your page.  The Configuration Wizard will automatically display, offering you the opportunity to quickly select display options, fields and other configuration items.

What are Master-Detail relationships?

Master-detail pages typically express a parent-child relationship between a parent record and its itemized detail in the child table.  For example, an Order record (the parent) may have multiple line items in the order in a separate Order Details table (the child).  Showing the line item detail on the same page as the parent record is a common need in many applications.

This page shows an example of a child table displaying the details relating to the parent record.

For example, if you an online store and need to keep track of orders and all of the items that have been ordered, then in relational databases such as Oracle, Microsoft SQL Server or Microsoft Access, you can create an Order table and an Order Item table as follows:

Table

Fields

Order

Order Id
Order Date
Name
Address

Etc.

Order Item

Order Item Id
Order Id
Item
Unit Price
Quantity

Etc.

In this example, the Order Item table is considered a ‘child” table (also called a “detail” table).  The Order table is considered the “master” or “parent” table.  The reason the Order Item table is considered a child table is because it contains a reference to the Order table using the Order Id.

However, just adding an Order Id field to the Order Item table is not sufficient.  You also need to tell your database about the relationship by establishing a “foreign key” relationship between the Order Id field in the Order Item table and the Order Id field in the Order field.  When you define this foreign key relationship, your database can enforce the relationship between the two tables and ensure that your data has “referential integrity”.  For example, if you attempt to delete an order from the Order table, your database will not allow the deletion of this order until all of the related order items in the Order Items table that refer to the order are deleted as well.

Virtual Foreign Keys and Master-Detail Pages

Sometimes, you may not be able to define the foreign key relationship in the database itself because you lack permission to change the database’s schema.  In this case, you can define the foreign key relationship as a “virtual foreign key” in Iron Speed Designer.  The Virtual Foreign Key (VFK) relationship emulates a Foreign Key relationship as far as your application is concerned.

See Also

Panel Type Selection

Panel Options Selection

Panel Fields Selection

Table Search Configuration

Table Filtering and Sorting ConfigurationTable Column Total Configuration