You get T9 because it is a txt field, and textSort.
You have to sort on number.
Look at "DemoMaxPoA20022003.mdb" (attachment, zip).
Look at Table, Query. Run Query2.
Adapt it in your mdb.
You can to change a RELATIONSHIPS in the query,
independantly of that in the Relationships.
If you want, send a short example of your mdb (access 2000 or 2002-2003),
and tell what you want to do.
1) Make another table with the same fields.
2) In this table make ID = Primary key.
3) Make an append query. Input is your table, output is this another table.
4) Run this query.
5) Delete first table.
If you have got a REFERENTIAL INTEGRITY (in the RELATIONSHIPS) between these two tables, you can't to write a record in the table "JOB LOG". You must
write the record in the table "CUSTOMERS" before.
You can't to build a house starting from the roof.
I think you don't need so many tables, (and forms).
Look at "DemoPaymentA20022003.mdb", (attachment, zip).
Look at Tables, Forms(VBA), RELATIONSHIPS.
Adapt it in your mdb.