Configure N:N relationship tables.
See more :
Image1: Generated application with associated tables
This link is treated as a field in the Form application. Define Field name, Data type, Label and specific Connection for this link. For specific connection is displayed a select with the project available connections.
Image2: Create a relationship field
Define the select (lookup) data source. Enter a select command or base it on a table.
Image3: Enter a select command.
For the option Choose Table 3 objects select are displayed allowing to choose the table and the fields Key and Description.
Image4: Select command base on a table.
Select Command to display the update field values available.
Image5: Select Command.
Image7: Field object type.
Image8: Relationship table.
Define the relationship table updated.
Image9: Select table.
Image10: Link key.
Define the application fields related to the relationship table fields.
Image11: Defining update table field values.
Image12: Lookup field.
Define the lookup table field related to the relationship table.
Image13: Defining table foreign key.
Define the values stored in the relationship table fields that are not foreign keys.
Image15: Defining field attribute.
Image16: Double Select Filter.
Define a search to the relationship table.
Image17: Search field settings.
Image18: Display Settings.
Documents the application. Create on-line instructions, describe business rules and save comments in the System Help to allow users to better understand the system and instruct them in the best way of interacting with the applications.
Tooltip - Add text that will be displayed when the user hovers his mouse over the field.