Hi,
I have 2 SQL tables, simplified here:
Queries(QueryId , QueryName)
UserQueries(Que ryId)
My comboxes in a grid show the existing records in UserQueries, and the
Add row allows the user to select a query and add it to the UserQueries
table. Of course the display member is QueryName and the value member
is QueryId.
Now the issue is, I don't want the user to select a Query that has
already been added to UserQueries, therefore the comboboxes are filled
only with the Queries records that are NOT in UserQueries, and
therefore existing UserQueries records shown in the grid appear with
their QueryId only (as there is no QueryName to bound them to). How can
I overcome this problem ?
Hope this was clear enough
Thx
I have 2 SQL tables, simplified here:
Queries(QueryId , QueryName)
UserQueries(Que ryId)
My comboxes in a grid show the existing records in UserQueries, and the
Add row allows the user to select a query and add it to the UserQueries
table. Of course the display member is QueryName and the value member
is QueryId.
Now the issue is, I don't want the user to select a Query that has
already been added to UserQueries, therefore the comboboxes are filled
only with the Queries records that are NOT in UserQueries, and
therefore existing UserQueries records shown in the grid appear with
their QueryId only (as there is no QueryName to bound them to). How can
I overcome this problem ?
Hope this was clear enough
Thx