Step 1: Prepare 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 1a: Create child tables for one-to-many relationships

Step 1b: Create separate lookup tables

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

Step 1d: Explicitly declare primary keys in your database

Step 1e: Explicitly declare foreign keys in your database

Step 1f: Declare virtual primary keys in Iron Speed Designer

Step 1g: Declare virtual foreign keys in Iron Speed Designer

See Also

What is an Iron Speed Designer Application?

Creating Your First Application

Step 1: Prepare your Database

Step 2: Select the application type

Step 3: Select a Web Page Style

Step 4: Connect to a Database Server

Step 5: Select Pages to Create

Step 6: Select Virtual Primary Keys and Virtual Foreign Keys

Step 7: Select Language and Localization Settings

Step 8: Name Your Application

Step 9: Build Your Application