Thanks for your help. I think what I'll do is just setup a second view. Most of the time when I need all records, I am also including child records from multiple tables that are not related to each other. I'll use that view for my list, and the original view for editing.
>I use to use characters strings as my primary keys, but now I would like to use integer keys. With characters strings as my PKs, I was able to set up a parameterized view that would let me select either one record or all records from a table. If I wanted one record, I would set my view paramter like this:
>
>lcJob_ID = "00001"
>
>before I required the view. If I wanted all records, I would set the paramter like this:
>
>lcJob_ID = SPACE(0)
>
>Can I do the same thing if I use integer PKs?
>
>BTW, the US Women's soccer team rocks!
Chris McCandless
Red Sky Software