Table Relatioships

• yrstruly

  Hall of Fame

  Points: 3477

  More actions

  March 31, 2022 at 11:16 am

  #4008770

  Please assist?

  I would like to join the dataset attached to be able to run queries. My Data Model in theory:

  

  I am getting the error below when i try to join the rest of the tables.

  

  For reporting purposes the data must be joined to get desired reports. bak file:https://drive.google.com/file/d/148HhjQjwXwTMkuhmpKlhDOrUovsQBdkA/view?usp=sharing

  To get primary keys, i joined more than one column in certain tables.

• ratbak

  Default port

  Points: 1405

  More actions

  March 31, 2022 at 1:15 pm

  #4008814

  The error is telling you the problem -- all the columns used in a foreign key must be all the columns in a unique index on the primary table. If the primary table has a multi-column primary key, all those columns must comprise the foreign key.

  You don't have to join tables on foreign keys in queries... but you would need to handle any data duplication that might result if the joining columns are not unique.