Any one use Access Database?

To answer the question at hand, you can't have it both ways: you can sort by either ID or Title. There really is no reason to care about having ID in order unless you want to see the order of entry. I'd be more interested in sorting by song, artist, date of release, etc.

You should probably think about having Artist and Song tables that are related to the Cassette table. This way every song and artist is only stored once and then related to the cassette table.



Mike