Relation Field
Last updated
Last updated
Label Field • The first input field allows you to specify the Label of the column. • Enter a meaningful name, such as “Category” or “Author”, to indicate the purpose of this column. This label will appear as the header for the column in the table view.
Type Field • The second dropdown menu is used to select the Type of data for the column. • Choose Relation to establish a relationship between this table and another table, enabling data linkage and retrieval.
Relation Configuration • Once Relation is selected, three additional multi-select inputs are displayed:
1. Relation Type: • Select the type of relationship, such as Many-to-One (M2O) or Many-to-One (M2O). 2. Table To: • Specify the table to which this field should relate. This is the target table where the related data resides. 3. View Fields: • Choose one or more fields from the target table to display as a reference in the relationship.