GST Billing Software

header image

Preferred Settings in Dialog Box

Erachana Line

9. How to change the Associated Keys of the Form?


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.

AssociatedKeys

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.