>Hi,
>
>I want to go to a previous record in a remote view. I maintain my primary keys in a seperate view and in that I fetch p. key < curent p.key and retrive my main view based on the value I get from the p. key view. But, it retrieves the least p. key value. ex. if the p.keys are like 2,4,5,6,8,9 and if I am at 6 and try to find previous, it finds 2. I guess it is b'cos it starts from the beginning of the table. How can get 5 and not 2?
>
>Please help
>Thanks
add Order by p.key Descending
Edward Pikman
Independent Consultant