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



      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