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