Connecting to tables in external databases

[ask180]

I have successfully connected to tables in an external MySQL database from AwareIM.

The last step is to define shortcuts, which I believe is allowed, but I get the following error:

"Only shortcut attributes can be added to business objects persisted in external tables. However, you do not have any reference attributes defined, so shortcut attributes cannot be created."

The external tables have foreign key constraints (eg: CONSTRAINT FOREIGN KEY (InstitutionID) REFERENCES institution (ID)), but the error persists.

So, can anyone explain to an SQL novice what is meant by "reference attributes"? I would have thought that foreign key constraints would do it.

[aware_support]

When you were discovering attributes you should have been asked a question whether to use foreign key constrains to create references. Make sure that you answer yes.

[ask180]

Thanks Support,

Works very well.