Table Relatioships

  • 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:

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

  • 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.


Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply