Employee/Job Assignment

[scbates]

We assign employees (N=65) to Job Type (N=5) and Job Title (N=many) every six months.

Before we begin, we know the employees and the job titles.

There are two phases: assignments and distribution.

Assignment:

1. I assign individual employees to individual job types and titles.

Distribution:

1. Employees get sent a list of their job assignments for the work period.

We need to:

1. Make sure that every employee has a job type and title.
2. Make sure that every job title has an employee.

What is the best set up for this kind of task? Is it just one big table? is it two tables (employees, jobs)?

I FEEL like this is a job for linked records, but no matter how hard I try, I can't figure it out--I've been doing this on a spreadsheet but there's gotta be a better way (particularly because I have to do this twice per year).

-Scott

[TheTimeSavingCo]

Hmm, I think I'd have 2 linked tables:
1. Employees
  - This would also include a "Job Type" single select field
2. Job Titles

In "Job Titles", I'd have a view set up which displayed all the records that have no linked record to "Employees"

So during the assignment, I'd just need to make sure that all the records in "Employees" had a "Job Type" value, and all the records in "Job Titles" are linked to a record in "Employees", does that make sense?