>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.
>
This is exactly what QBF Builder does for you...and does it all automagically.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer