>Thanks for that.
>
>That was the sort of thing I was going to put in. I have noticed that when opening Views it can take a while, but when you just requery them, it's pretty quick.
>
>I do, however, have one more snag, and that is the fact that the buttons used to open my Container screens, highlight in BLUE if there is data behind them - I can't think of a way of getting around that without running more Select statements!!
>
>Kev
Create a parameterized SQL view based on something like the following.
Create SQL View lv_Kounts as ;
select ;
sum(iif(ID = ?cValue1, 1, 0)) Kount1, ;
sum(iif(ID = ?cValue2, 1, 0)) Kount2, ;
sum(iif(ID = ?cValue3, 1, 0)) Kount3 ;
from MyTable
Your buttons would be BLUE/Enabled if the correcponding KountX field is greater than 0.
Mark McCasland
Midlothian, TX USA