failed to reference column for PK and FK in Table Editor

[martine.yung]

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

[blafond]

The behavior for creating PK/FK's in 7.1 hasn't changed from 6.x

See: http://docs.jboss.org/teiid/designer/6.0/user-guide/editing-model-objects-chapter.html#create-new-association-section   for details

Barry