Types & Sub-types

[agtjazz]

Hi there

I have a question about the best method for setting up types & sub-types.... I am developing a "new and improved" personnel database.

We want to track 3 types of Employees: Faculty, Staff, Student Assistants

Under each type – there are sub types:

-For Faculty—we could have Tenure Track, Tenure, Graduate Assistant etc

-For Staff- --- we could have Permanent, Probationary, Volunteer , etc

-For Student Asst--- we could have Bridge, Work Study etc

So do I set up a table for Employee Type and each combination is a record?

i.e.

F-tenure track

F-tenure

F-Graduate Asst

S-Permanent

S-Probationary

SA-Bridge

SA-Work Study

Is there a better way that I am not thinking of? Any assistance will be greatly appreciated.

Have a nice day.

[mz123]

If I understand what you are trying to do, I would recommend the following:

Set up a table with Employee Type, Tenure Track, Tenure,... Work Study as fields.

In layouts, create three layouts that look similar but have different fields, based on Faculty fields, Staff fields, Student Assistants. With this approach, you would have to make sure the correct Finds are being done so that when a user clicks on the "Faculty" tab, only Employee Type = Faculty would show up.

From there, you could make a fourth tab that gives you all the types of employees and has a concatonated field with details so that it would look something like this:

Employee: John Doe

Employee Type: Faculty

Details: Tenure Track - blah blah blah; Tenure: blah blah blah

so the concatonation would look something like

If(Tenure Track = ""; ""; "Tenure Track: " & Tenure Track) and so on.

Let me know if this works for you or if you need me to give better details of what I mean.

[agtjazz]

Thanks for your advice... I actually decided to make 2 tables, employee type and employee sub-type. I think for the reports and stuff that we will need, this solution will work more efficiently for us.

Have a great day!