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.
Example Use Case
• For instance, if you are working on a Products table, you could create a Relation column to link each product to a specific Category from the Categories table. In this case:
• The Relation Type could be Many-to-One (M2O).
• The Table To would be Categories.
• The View Fields could be set to display the Category Name field from the Categories table.
