I am starting a data base from scrach for a library of thousands of video tapes. The company I work for is broken up into many differnt departments and groups. The videos need to be sorted into the appropriate category. The fields that accompany the are the same for all (Date, Program Title, Footage Type, Agenda and the big one which i assigened ten seperate feilds Speekers). Currently I have all of the different categories in seperate tables which has been brought to my attention is wrong and that all the categories sould be merged together? If this is the case should i merge them all together and then create a combo box with a list of all the categories? and for identification purposes the tapes have to have a number but the number has to corospond with the category the video fall under or even better a system that combines the categoty name and a number but the number in each category need to start at 1. an example of the key I am trying to create might look like this Coprorate 1 or COR1 and the next would be COR2 and so on for each category. Can anyone help? Can anyone help me?