pcsoft.us.windevCopyright 2026, PC SOFT11 Apr 2018 10:38:03 Z10 Apr 2018 20:49:36 ZHi all I have a strange issue with unique compound index; WarehouseCode and LocationCode fields are both indexes (not unique) WarehouseCodeLocationCode is a compound index of the above and is unique if i create data WarehouseCode="MAIN" LocationCode="A1" then i create data WarehouseCode="MAIN" LocationCode="A-1" i get a DUPLICATE error ? against the individual field indexes, accent and punctuation sensitive settings are ticked. against the compound index, accent and punctuation sensitive settings are unticked and 'greyed out/disabled' Any ideas anyone ? help would be much appreciated cheers Dave30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65175-unique-index-compound-issue-duplicate-record/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)dsprosystemspcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65175-unique-index-compound-issue-duplicate-record-65181/read.awp11 Apr 2018 10:38:03 Z[SOLVED] Many thanks Fabric, that has solved the issue, once again you have provided tremendous help Very much appreciated…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65175-unique-index-compound-issue-duplicate-record-65181/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65175-unique-index-compound-issue-duplicate-record-65181/read.awpUnique Index compound Issue / Duplicate Recordfromwebpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65175-unique-index-compound-issue-duplicate-record-65177/read.awp10 Apr 2018 22:25:06 ZHi Dave, the fact that the components of your compund index are indexes themselves is irrelevant, and so is their settings …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65175-unique-index-compound-issue-duplicate-record-65177/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65175-unique-index-compound-issue-duplicate-record-65177/read.awpUnique Index compound Issue / Duplicate Record