>>I will try this, but the monkey wrench in this is that I use the view designer in the database to create and maintain my views. You have the statment DELETED() as deleted, how can this be accomplished using the view designer versus creating it on the fly. I can get around this but I am just curious. I will test you steps shortly.
>
>
>Not to hard... when you are in the View designer, on the Fields tab, at the bottom of the field list is a text box labeled 'Functions and expressions:'.
>
>Just type
>
>deleted() as deleted
>
>into that text box, and press the ADD button.
>
>BOb
Thanks, now I will use that and try your method and see if I get good results. I will let you know.
Bret Hobbs
"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope