Once you have imported some data, the next step is creating the relationships between the tables. If you have imported data from a database where primary and foreign keys have already been defined, then these should be imported along with the tables. However, you may find that these relationships are not suitable for your data model. You may also have more than one relationship between tables, where only one will be active. In addition, you may also want to create new relationships.
A relationship is defined by a single column from each table. You cannot use multiple columns to define a relationship, but you can create new columns in each table that consist of multiple columns concatenated together. You can then use these to ...