your want ALL but not items Selected - select id from table where in in
(select id from table where id not in (select items))
J
At 04:35 PM 5/9/2008, you wrote:
Not following you. I could have an item "ALL", but I want "ALL but those
that are selected". So far, Alastair wind with his simple button method,
unless I decide to test a cursor with a bunch of MAKECLICKs. I was hoping
someone else had already done that and could tell me if it works, but I'll
just invest a little time and try it myself!
Karen
Karen - you may want to include an item called '_ALL' and then have the
program test for that number
J
At 02:38 PM 5/9/2008, you wrote:
Jan:
Good thought, but let me tell ya why this won't work for me. The client
still needs to be able to just check 1 or 2 items; they won't always
want to do the "select all". In order to do that, I'm assuming you
suggest that I do a scrolling region, with a checkbox for the Y/N
field. Unfortunately I don't like doing this because you have to do 2
mouse clicks in order to change the checkbox. The first mouse click
highlights the row and gives you focus; the second mouse click changes
the check box. My clients don't like that. I want the ability to do
a one-click select, plus the ability to select all. Basically like a
regular old ChkBox choose list, but as a nicer form control rather than
a popup menu...
Karen
J. Blaustein
J Blaustein Associates, Inc
12 Herrick Drive
Lawrence, NY 11559
516-371-3445
fax:516-371-4761
