Hi, 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??
Edited 1 time(s). Last edit at 07/29/2018 07:57AM by GuenterP.