Jump to content

Types & Sub-types

This topic is 6086 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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?


F-tenure track


F-Graduate Asst




SA-Work Study

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

Have a nice day.

Link to comment
Share on other sites

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 :D

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.

Link to comment
Share on other sites

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!

Link to comment
Share on other sites

This topic is 6086 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.