Rational Tables?

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/7071-rational-tables.html
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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7071
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?

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7071
http://www.mvps.org/access


"Scooper2241" wrote:

> 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7071
> 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?