>Yes, I know how to do the SELECT statement, but because of the volatility of the data (new members being added by multiple users every day) I have to call the select statement every time they enter the member screen. The 2 to 3 seconds it takes for the statement to load gets to be an aggravation after awhile. Does anyone have an idea about how to do this without having to constantly update the cursor??
>
>Sorry I wasn't clear enough...
>
Hi Vicki,
I would consider creating such a table only after I exhausted all alternatives. How big are tables? Do you have appropriate indexes? Did you consider using SCAN/ENSCAN in combination with SEEK or SET RELATION TO to build the list?
--sb--