1 Reply Latest reply on Nov 12, 2010 1:04 PM by Barry LaFond

    failed to reference column for PK and FK in Table Editor

    Martine Yung Newbie

      Hello,

       

      What is the correct process to define PK / FK with Teiid Designer 7.1.0 ?

       

      I have defined PK/FK but I still have error, because reference column are missing.

      Error is "the Foreign Key must referenced 1 or more column; they are none"

       

      Using Table Editor (PK or FK tab),  I use the "..." button to select columns for FK or PK, but I have strange behavior, because the list of available columns is sometimes empty or contains only 6  up to 923 columns available in my model.

       

      I have tried also to select FK from Columns tab view, but I have the same issue, the list of available FK is empty or not correct.

       

      Thank you for your help,

       

      Best regards

       

      Martine