M
Mike Morton
Hello
I want to create a dynamic form, which will create and remove fields from a
form based on the data accessed. The field names, data types and data
source names are stored in a 'configuration' table, which links to a key
name in the main data table.
This setup currently works by having all the fields permanently on the
form - but invisible, showing only when required. This, however, doesn't
give me the ability to reorder their tabindex, which can be frustrating for
the user.
I have a Records table :
RecordID
RecordType ** LINK
Field1
Field2
Field3
etc.
and a configuration table:
RecordType ** LINK
Field1Visible
Field1Order
Field1Top
Field1Left
Field2Visible
Field2Order
Field2Top
Field2Left
Field3Visible
Field3Order
Field3Top
Field3Left
etc.
Can I use the information in the configuration table to add (or remove)
fields from the form at runtime, as the record pointer in in the main table
changes ?
Many thanks (in advance)
Michael Morton
I want to create a dynamic form, which will create and remove fields from a
form based on the data accessed. The field names, data types and data
source names are stored in a 'configuration' table, which links to a key
name in the main data table.
This setup currently works by having all the fields permanently on the
form - but invisible, showing only when required. This, however, doesn't
give me the ability to reorder their tabindex, which can be frustrating for
the user.
I have a Records table :
RecordID
RecordType ** LINK
Field1
Field2
Field3
etc.
and a configuration table:
RecordType ** LINK
Field1Visible
Field1Order
Field1Top
Field1Left
Field2Visible
Field2Order
Field2Top
Field2Left
Field3Visible
Field3Order
Field3Top
Field3Left
etc.
Can I use the information in the configuration table to add (or remove)
fields from the form at runtime, as the record pointer in in the main table
changes ?
Many thanks (in advance)
Michael Morton