>The alternative is to create a table called list;
>
>Create table list (;
> userid INTEGER, ;
> parameter C(254) )
>
>Delete all records in list for the matching userid (this user) and then add any items that match the selected parameter.
>Your IN table then joins to this list table with two parameters, the userid and the parameter field matching whatever other field you need. This allows multiple users to access the table independent of each other.
Hi Bob. I like your file suggestion. It was one I was considering but hadn't figured out the multiple user problem which you so neatly solve. I am, however, doing it by creating a cursor in code. I just have this thing about having to do in code what could so nicely be handled by a parameterized view if only it worked as semi-advertized.
Thanks for your input. It helped confirm my own thinking.
***************************
Bruce Gilmour
"Two things are infinite, the Universe and human stupidity. And I am not sure about the Universe."
- Albert Einstein