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