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.