By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,815 Members | 1,151 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,815 IT Pros & Developers. It's quick & easy.

probleme with databound comboboxes

P: n/a
Sam
Hi,

I have 2 SQL tables, simplified here:

Queries(QueryId, QueryName)
UserQueries(QueryId)

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

Nov 21 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.