Database design » Create a one-to-many relationship

To create a relationship, click the Relation icon as shown below and then drag the mouse cursor in the direction from the parent to the child table. creating a relationship (foreign key) Specifying the exact columns will create a relationship between them. Selecting table headings (without indicating columns) will result in the creation of new fields, between which a relationship will be created. Also note that the related columns should be of the same type. editing relationship properties An example relationship is shown in the picture below: relationship after insertion The name of the relationship, the columns that compose it and its other features can be edited in the property panel. editing relationship properties

This site uses cookies. Learn more about the purpose of their use and changes in cookie settings.
By using the website you agree to the use of cookies in accordance with current browser settings.