Replica ID's

[Guest]

Using a replicated database (Split FE/BE etc) to log drill core, I have run
into a problem where the input forms are sorted by the random number ID
generated by the replica.

This causes all the previously input data sheets (records) to become random
rather than be sequential running deeper down the hole if the database is
closed and reopened. A bit of a problem if you need to go back to the start
of the hole and add data to each record.

Any ideas on how to get around this problem?

Thanks.

 

[Joan Wild]

I take it you have some field that indicates the depth of the hole at each
stage? Use a query as the recordsource of your form and sort on that field
instead.