>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
Edgar L. Bolton, B.S. B.B.A.