Rational Tables?

[Guest]

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?

 

[Guest]

Yes, build a new table for categories and add a field CategoryID to your
existing table.In the form for data entry, add a combo box to display and
edit the data.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access