[HEADER] 
type = module 
app = it 
role = it 
name = Module Maker
menu = it.mm
table = MODULES
`sql-order-by = NAME
clear = true 
query = true 
new = true 
edit = true 
delete = true 
query-on-next = true
default-mode = clear
after-new = clear
 
[FIELDS]
`                                                                  Writable? 
` Bound field	 variable            type           label          new edit Req Lookup?
`
MODULE             moduleField          Double BoundDouble    ""          N N N N N ()
TYPE               typeField            String FixedComboBox  "Type:" Y Y Y N N (new String[][]{{"M","Module"},{"O","Object"},{"T","Table"}})
APP                appField             String FixedComboBox  "App:" Y Y Y N N (new String[][]{{"O","Operations"},{"A","Accounting"},{"I","IT"}})
DBROLE             dbroleField          String FixedComboBox  "DB Role:" Y Y Y N N (new String[][]{{"O","Operations"},{"A","Accounting"},{"I","IT"}})
NAME               nameField            String CharField      "Name:"      Y Y N Y N (30,20,CharField.MIXED_CASE)  
MENU               menuField            String CharField      "Menu:"      Y Y N N N (30,20,CharField.MIXED_CASE)  
BASE_TABLE         baseTableField       String CharField      "Base Table:"      Y Y N N N (30,20,CharField.UPPER_CASE)  
HAS_CLEAR_BUTTON   hasClearButtonField  String CharCheckBox   " "         Y Y Y N N ("Y","N","Clear Button?") 
HAS_QUERY_BUTTON   hasQueryButtonField  String CharCheckBox   " "         Y Y Y N N ("Y","N","Active Button?") 
HAS_NEW_BUTTON     hasNewButtonField    String CharCheckBox   " "         Y Y Y N N ("Y","N","New Button?") 
HAS_EDIT_BUTTON    hasEditButtonField   String CharCheckBox   " "         Y Y Y N N ("Y","N","Edit Button?") 
HAS_DELETE_BUTTON  hasDeleteButtonField String CharCheckBox   " "         Y Y Y N N ("Y","N","Delete Button?") 
QUERY_ON_NEXT      queryOnNextField     String CharCheckBox   " "         Y Y Y N N ("Y","N","Query on Next?") 
DEFAULT_MODE       defaultModeField     String FixedComboBox  "Startup Mode:" Y Y Y N N (new String[][]{{"C","Clear"},{"Q","Query"},{"N","New"}})
AFTER_NEW          afterNewField        String FixedComboBox  "After New Mode:" Y Y Y N N (new String[][]{{"C","Clear"},{"Q","Query"},{"N","New"}})
 
[TRIGGERS]
initialize {
  return true; 
}

whenNewRecord {

  if ( isInserting() ) {
    try { 
      moduleField.setValue ( getSequence ("module_seq") );
      System.out.println ("Module # " + String.valueOf (moduleField.getValue())); 
    } catch (SQLException ex) {
      getDbManager().handleSQLError (ex, this);    
      return false;
    }
  }
  
  return true; 
}

[CODE]