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

    Synthetic key in table structure

    Stefan Fischer





      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.