>>D Use a parameterized view, where the parameter is the 2-char information. There are threads about parameterized views. If you haven't used one, then it's just a standard view, except in the WHERE clause you put a question mark in front of the variable on the right "WHERE Myfield = ?Myvar" When you load the view, if the program can't find MyVar it will ask you. Usually you set this value programatically. You WILL need an index on the field.
>>Barbara
>
>Barbara, Love the Parameterized view goes right along with
>the user process steps.
>Sorry it takes me so long to get back to you, I have several
>balls in the air juggling act.
>A good enhancement would be to 'programaticaly' ignore the
>parameter request for top management - all data access...
>ie, the same SQL view would be without WHERE condition.
>
>Thanx- Ed B
Ed, you don't even need to ignore the WHERE for top management. Add an if or case statement which will set the parameter to ''
Barbara