Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Rational Tables?

Discussion in 'Information Technology' started by Scooper2241, Nov 10, 2005.

  1. Scooper2241

    Scooper2241
    Expand Collapse
    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?
     
  2. Loading...

    Similar Threads Forum Date
    Is Sikh Philosophy Empiricism or Rationalism? Sikh Sikhi Sikhism Oct 21, 2014
    Inspirational Pictures - Yes, Why? Inspirational Stories Oct 28, 2013
    USA Rationalist Society on COW URINE CRAZE (in Punjabi) Breaking News Jan 14, 2013
    Inspirational film fun for girls, boys, dads and Soccer Moms Sikh Youth May 22, 2010
    Atheism Rational Theists and Rational Atheists of the World, Unite! Interfaith Dialogues Mar 25, 2010

  3. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    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


    "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
    > 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?
     

Share This Page