Step 1: Create child tables for one-to-many relationships

Well-normalized database structures work best since Iron Speed Designer creates a suite of pages for each database table and view you select.  Well-normalized databases have explicitly defined tables to express most concepts, making it easy for Iron Speed Designer to create a more comprehensive application.

Iron Speed Designer creates master-detail (parent-child) pages based on the one-to-many relationships in your database.  For example, one order may have multiple line items.  Accordingly, a well-structured database would have both an Orders table (master) and an OrderDetails table (detail).  A foreign key field in the OrderDetails table identifies the parent record in the Orders table.

When Iron Speed Designer creates web pages for the Orders table, it will automatically join the OrderDetails table and include it as a separate panel on the page, creating a master-detail page.


Master / parent / one

Detail / child / many




one customer may have many orders



one order may have many line items

See Also

Step 1: Create child tables for one-to-many relationships

Step 2: Create separate lookup tables

Step 3: Create database views to express multi-table joins and complex queries

Step 4: Explicitly declare primary keys in your database

Step 5: Explicitly declare foreign keys in your database

Step 6: Declare virtual primary keys in Iron Speed Designer

Step 7: Declare virtual foreign keys in Iron Speed Designer