>I have a view of remote data that contains one record (the table is to large to download all of it locally each time). How do I requery the view to go to the next record (or previous) record. The primary key is sequential but records can be deleted so the primary key could be 1,2,3,99,203, etc. I thought about taking the current record's primary key and then in a loop add 1 to it until a record is found but this does not seem very efficient. I would appreciate any help.

An idea: use a second view, which selects MIN(primarykey) WHERE primarykey>yourcurrentkey, and then requery the first using the key you got from the second view.

HTH!