Using "types" table for multiple other tables

[Linda RQ]

Hi Everyone,

I think I can do this but I want to make sure. I use Access 2003
I have a database with employees. There are many other tables but these are
the tables I need to have help on.

Purpose is to document the levels of discipline an employee has recieved for
Attendance. I am anticipating there will be other requests later on, like
for Behavior, etc so my question is, can I use my tblDiscplnTypes for other
tables later on since they are the same types but for different catagories?

Also, does the design look right?

tblEmployees
EmpID_pk
EmpLName
EmpFName
Etc...

tblHR500Atndnc
HR500AtndncID_pk
EmployeeID_fk
HR500Date

tblDiscplnTypes
DiscplnTypesID_pk
DiscplnTypeDes
DiscplnTypeComments


Thanks,
Linda

 

[Klatuu]

Yes

 

[Linda RQ]

After I drew my design out on paper, I though I should put the comments
field in my tblHR500Atndnc instead of the tblDiscplnTypes since there may be
comments that go with the discipline not the types. Am I mixed up?

Thanks,
Linda

 

[quinto via AccessMonster.com]

I am a novice but, I have a similar database.
I created a RecordsTable with the following fields: Empl ID, DDate, Comments,
Code, ADate, Action Taken.
I created drop down menu for codes and they cannot be changed so the same
codes will be used. I aalso addeed a drop down menue for action taken but it
can be edited or overwritten with the desired action.
I joined the Emplname table and the RecordsTable and I use a number of
queries to generate reports that will include the type of information wanted
based on the code used.
You can add other information, for eaxample I have added Safety points and
Attendance points because they are used for bonuses at the end of the year.
I came from a large agency so I lke to use Empl ID and not names to join
records
This is very basic for an amateur

Quinto

 

[Linda RQ]

Thanks Quinto. I like the safety points idea.

I am a novice but, I have a similar database.
I created a RecordsTable with the following fields: Empl ID, DDate,
Comments,
Code, ADate, Action Taken.
I created drop down menu for codes and they cannot be changed so the same
codes will be used. I aalso addeed a drop down menue for action taken but
it
can be edited or overwritten with the desired action.
I joined the Emplname table and the RecordsTable and I use a number of
queries to generate reports that will include the type of information
wanted
based on the code used.
You can add other information, for eaxample I have added Safety points and
Attendance points because they are used for bonuses at the end of the
year.
I came from a large agency so I lke to use Empl ID and not names to join
records
This is very basic for an amateur

Quinto