We have two free tables that are related by invoice number, InvoiceA, and InvoiceB. InvoiceA contains the accounting information for a customer's invoice. InvoiceB contains the line items.

Both contain invoice number fields that are 5 digits long (they're numeric fields). InvoiceA is indexed on the Invoice field but InvoiceB is indexed on the STR(Invoice,5)+CATALOGNO. That way, invoices appear in the proper alphabetical order (by catalog number) on the invoice and on computer screens.

We are about to reach the rollover of 99,999 to 100,000 and have converted the invoice number fields from 5 digits to 6. InvoiceA and InvoiceB are now related by STR(Invoice,6). InvoiceB is indexed on STR(Invoice,6)+CATALOGNO.

Since the programs are designed for 5 digit invoice numbers there are bound to be many problems. Is there a graceful way of minimizing them?
Thanks in advance.