Chris,

It's a bit awkward, but you could paramaterize your view on this:

JobID >= ?m.liJobLow AND JobID<=?m.liJobHigh

To get one record set liJobLow and liJobHigh to the key. To get them all set liJobLow and liJobHigh to the min and max values of an integer key: -2147483647 and 2147483647 respectively.

>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!