Preparing Your Database

Iron Speed Designer creates a wide range of web pages for each database table and view you select.  The quality and comprehensiveness of your application depends, in part, on your database design.  The more complete it is, the better Iron Speed Designer can do.

Here are the steps you should take to prepare your database:

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