pcsoft.us.windevCopyright 2026, PC SOFT30 Jul 2018 08:13:00 Z29 Jul 2018 07:57:00 ZHi, as an example, I have a simple table control here, item# + quantity: [attachment 2773 Bestellungen.png] The problem: the combo in column 1 of the table should contain only those item numbers which are not in the table. Is there a query for that? Of course, currently I'm doing that by code and fill the combo with all of the items which are NOT already in the table (TableSeek ..). Is there a more elegant way by query??30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66390-wd23-query-question/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66390-wd23-query-question-66401/read.awp30 Jul 2018 08:13:00 ZHi Michael and Shijo, thank you, I'll try to get one of your suggestions to run!https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66390-wd23-query-question-66401/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66390-wd23-query-question-66401/read.awp[WD23] Query Questionguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66390-wd23-query-question-66400/read.awp30 Jul 2018 08:03:00 ZHi Gunter, "Good Day" You can use "Not In" in SQL query. Create a string and add all current using IDs separated by Com…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66390-wd23-query-question-66400/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66390-wd23-query-question-66400/read.awp[WD23] Query Questionguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66390-wd23-query-question-66399/read.awp30 Jul 2018 07:15:00 ZHi Guenter, you could create a variable like "Artikel_Liste" and add each GUID (or ID) of the selected product as string with…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66390-wd23-query-question-66399/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/66390-wd23-query-question-66399/read.awp[WD23] Query Question