Form Storage -- Flat Table

The Flat Table storage mechanism allows you to map any flat table that you have in your database into a form. This is done by specifying:

• A form name
• The table to use
• A way to associate each row of the table to a unique 'id' which will be used as the form's id. This can be done as either:
  • Specifying a column as the 'id' column
  • Specifying a SQL function that produces the 'id'.
• The columns of your table that you want to associate to fields of your form
• The FormField type for each of these associated fields
• Any mappings between your fields to fields of another form
• Whether you want this table to be read-only or read-write.
• An optional parent form. This includes:
  • The form name of the parent form
  • A way to specify a parent form 'id' for each row of the table. This can be done as either:
    • Specifying a column of the table as the 'parent' column
    • Specifying a SQL function that produces the parent's forms 'id'.