Post reply

Table Relatioships

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

    8pod3

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

    8podmodel2

    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. 8podmodel

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

     

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

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