>Because I have a table with 10 invoices from
> April. But now I need to isert invoices
> from march too.
> These invoices have to go before the first
> record.
>
> Moises
Moises,
No they don't. You can create an index on invoice date and use that to order the records. The physical position of the records is meaningless when you use indexes.
USE Invoice
INDEX ON InvDate TAG InvDate
Do the above once and then whenever you want to see the invoices in date order you;
USE Invoices ORDER InvDate
BROWSE