On the assumption that each location 'owns' its own records:
use a different index range on records from the 2 locations
EG:
Main location from 1000000
Satelite location from 5000000.
Satelite sends records to main.
Main location appends satelite records to its own
Main sends combined...
Data from Previous Record (Queries only)
Can be acheived using queries only
The attached relies on the record numbers being consequtive in Scooterbugs "table 3"
Two queries are used:
"qry Prev"
Previous records
"qry Prev Finish - Start"
Differences between Start and Previous...