Relationship error

Hi,

I'm trying to create a many-to-one relationship between 2 tables using a text field as the common key, but this fails and I get an error message which I don't understand (see image below).

This is a mySQL 5.5.40 database running under Lubuntu 14.04, which in turn runs in a Virtual Box on Windows 7. InstantJChem version 15.1.12.0.

Please advice!

Kind regards,

Evert

evehom wrote:

Hi, I'm trying to create a many-to-one relationship between 2 tables using a text field as the common key, but this fails and I get an error message which I don't understand (see image below). This is a mySQL 5.5.40 database running under Lubuntu 14.04, which in turn runs in a Virtual Box on Windows 7. InstantJChem version 15.1.12.0. Please advice! Kind regards, Evert

Hello,

I am unable to reproduce your issue on MySQL 5.6.22, do you have a sufficient rights to create table in this schema?

Best regards,

Martin