Thanks Edward, it worked. Sometimes I just dont do much thinking and expect others to help me.


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