>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