>>>Hello Aaron,
>>>
>>> How large is your table? You can download just primary key and retrieve whole record in the navigation using these keys.
>>>
>>>:) But first you should try how long it takes to retrieve only PKs.
>>>
>>>Bye
>>>Jayesh
>>>
>>>>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.
>>>>
>>>>Thanks
>>
>>Hi, Jayesh! Have a question to you. Do you send your replies to my mailbox with a purpose to get some feedback or just accidentally?
>
>Hello Ed,
>
> Sometimes accidentlly and sometimes replies of the current topic being discussed.
>
>Bye
>Jayesh
What about today's two replies? And don't do it accidentally, please!
Edward Pikman
Independent Consultant