>I have a table with CDX index file tagged on an ID. I can display the data in a form in the order of ID, but my codes using RECNO() face a problem. RECNO() accesses the record in physical order but not the displayed record as I want. How to solve this?
Nond,
Stop using recno() and use the Primary key for the table instead. RECNO() is a remanent of xBase days gone by and using the physical record number is not a good way to handle things now.
If you can describe more thoroughly what you are trying to do I am sure we can give some advice on how to do it.