Question Register Database

[arka74]

Hi everybody,

I am in the process of creating a "Register Database". Me being a beginner in Access would like to get help in creating the database.

To register the jobs,
assigning a job number,
to have three cascading combo boxes - to get: the department name -> division name -> and the job requestor.

Then the search options

Please provide me with tips and informations

 

[G37Sam]

You need the following tables:
1) Departments
2) Divisions
3) Employee

Linked via one-many relationship. (One Department Many Divisions, One Division Many Employees)

Then you will need a table, Jobs, with the following fileds:

JobID => Autonumber (Primary Key)
JobDescription => Text
Department => Lookup
Division => Lookup
JobRequestor => Lookup

Report back once the above is accomplished

 

[arka74]

Thank you Mr. Sam,

I have created the following table.

Register - To register the drawings or tasks
Fields are :
DrgNumber (Primary Key, starting from a certain number as per the current manual register)
Title
Date
Department (to get from the 1st combobox)
Division( to get from the second combobox, displaying only the divisions in the above selected dept)
JobRequestor ( to get from the third combobox, displaying the employees in the above selected division)