5 Replies Latest reply: Jan 26, 2017 10:26 AM by Mathias Schindler RSS

    Synthetic key in table structure

    Stefan Fischer

       

       

      Hi

       

      who can help me to dissolve a synthetic key?

       

      There are 5 tables (Equipment, Wartungsaufträge, Arbeitsvorbereitung, Werkskalender, Arbeitsplätze) related with each other tables.

       

      The table Arbeitsplatz with key [Arbplatz] exists in the tables Equipment, Wartungsaufträge and Arbeitsvorbereitung. The work calendar has a key [KEY_Dat1] and the Arbeitsplätze a key [Arbplatz].

       

      The result should be that in the table Arbeitsvorbereitung both keys [Arbplatz] / [KEY_Dat1] and Wartungsaufträge also the keys [Arbplatz] / [KEY_Dat1] exist. Unfortunately, I cannot dissolve the key.

       

      In picture 2 shows how the connection should look.

       

      Regards
      Stefan