Normally, when the Form is created, Key (Primary Key) get associated with the Form. But some- times, there is a need to manually associate the Key. The scenarios where such a need occurs are -
1. When the Table Column (Primary Key) data type gets changed
2. When new columns are added or removed from the Table
To Associate Keys, select the Form, and in Properties Tab, select the Associations section, selectAssociatedKeys property. Click Collections and enter the Primary Key Column or Incrementing Column name and click Ok.
For Table Detail Entry, Table Grid Entry, Single Entry and Search Form, only one
Primary Key Column name should be provided. Donâ€™t give any spaces before or
after the table name.
For Parent Child Detail Entry and Parent Child Grid Entry Forms, three column names need to be provided. You have to Provide only one Column name in a Line. The first Column name provided is considered asParent tableâ€™s Key, second column name is considered as Child tableâ€™s incrementing key, and third column is considered as Child tableâ€™s Foreign key or Referencing key to the Parent table.
If the Rules mentioned above are not followed properly, error will be thrown during Form / expression compilation.
For Advanced Search Form and Custom Form, there is no table Association. If anything is added, an error will be thrown during Form/Expression compilation.