I am creating a DVD database in Microsoft Access. I have column called Dvd Title. I am sorting these out in alphbetical order.
I want to put a ID such as a DVD number in another column. How can i do this so that the dvd titles stay in alphbetical order and the dvd numbers stay in numerical order