What happens if you export to another table called COPY table. I am wondering if when you do a saved table to table import it will respect the default sort of the table and the records will come across in the correct sequence.
If that works you could have a hourly process run by a pipeline which word delete the records in the other table and reload them. You would set the key field in that other table to be the sort field.
Then you would have a relationship back to your real table based on that sort field and you would be able to coax the Record ID from your real table up into the Copy table.
The records and the Copy table will be sequential. So you can have a relationship of the Copy table to itself to look up the previous or next record ID and then get the record ID from your main table of the previous and next records into the Copy table.
Then lookup those Record ID values back down to the main table.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.commark.shnier@gmail.com
------------------------------
