Create a Common Lookup Table

Some developers maintain a single table containing look up values.  For example, they may have an Id and a Lookup Type in addition to the value in the database table.  There are ways ways to do this.

Create database views specific to each lookup type

In Iron Speed Designer, you can create a Virtual Foreign Key from the table to the View.  The Virtual Foreign Key feature can be accessed from the Application Explorer.  Expand the Databases node in the Application Explorer tree control, select the database, select the table and go to the lookup field. Click Edit and select the button that displays the Virtual Foreign Key, and select the View and the field that refers to it.

Code customization

To do this, override the InitializeFieldControl function in the TableRecordControl class within the customizable class file. The InitializeFieldControl is called for every field on the page. You will need to compare to see when you are initializing the drop down field and then populate the drop down by reading from the database.

There are several code customization examples in Iron Speed Designer’s Code Customization Wizard (Customize, Code Customization Wizard…).  Specifically see the example in the Filter Data section called Filtering Dropdown List Box Content.