pcsoft.us.windevCopyright 2026, PC SOFT22 Mar 2020 14:51:54 Z17 Jun 2013 14:14:00 ZHi , I encounter strange bugs in WM18 when import table to analysis. WM unable to import foreignkey if the link fields name of both table is not the same. for example will failed when import CREATE TABLE users ( users_key CHAR(36) NOT NULL PRIMARY KEY, user_name VARCHAR(100) NOT NULL, ); CREATE TABLE supplier ( supplier_key CHAR(36) NOT NULL PRIMARY KEY, supplier_name VARCHAR(200) NOT NULL , rc_ouser CHAR(36) NOT NULL CONSTRAINT fk_rc_ouser_key REFERENCES users (users_key) ON DELETE RESTRICT ON UPDATE CASCADE, rc_cuser CHAR(36) NOT NULL CONSTRAINT fk_rc_cuser_key REFERENCES users (users_key) ON DELETE RESTRICT ON UPDATE CASCADE ); if I change the "rc_ouser" to "users_key" then it work but i can't in this table design. any work around OTHER THAN CREATE FOREIGN KEY MANUAL.30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/40845-wm18-import-sqlite-table-analysis/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)Meredith GUYpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/40845-wm18-import-sqlite-table-analysis-67707/read.awp22 Mar 2020 14:51:54 ZGood day - did you ever get your foreign keys to work? I have a foreign key with exactly the same name as the primary key on the…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/40845-wm18-import-sqlite-table-analysis-67707/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/40845-wm18-import-sqlite-table-analysis-67707/read.awp[WM18] import sqlite table to analysis