A picture is worth a thousand words they say. Please refer to attached image to view a section of my Music database so that I can explain the problem:
You will see that the first Field is in sequential order, A0041 represents the Abba Album "Ring Ring", A0042 represents the Abba Album "Abba - The Album", A0046 represents the Abba Album "Waterloo" .... etc.
My problem is simply this: I would like the third Field, i.e. Track Number to also be in sequential order for each particular Album, i.e. I would like the Database to list Tracks A1, A2, A3, A4, A5, A6, B1, B2, B3, B4, B5, B6 in order for each Album. At the moment, as you can see, the tracks are listed in random order. Of course the Song Title (Field 7) should still correspond to the correct Track Number.
I am an old man and have taught myself what little computer skills I know, but this is beyond me. By the way this database, which now amounts to over 85,000 lines has been compiled over a period of 10 years. It represents my entire music collection of some 5,000 LP's and about 1,000 CD's. I guess it goes without saying (but I will say it anyway) that this database is very important to me!
This is my first posting on this Forum, in fact my first posting ever in any Forum. I do hope that someone will help me with this problem. Thanks in advance and I'll keep my fingers crossed.