Building databases

M

mc2computing

I am attempting to build a database that will have a list of employees by
date of hire that I can compare to a list of 'extra' work available and
assign by seniority. Can anyone guide me down the right path?
 
L

Larry Linson

I am attempting to build a database that will have a list of employees by
date of hire that I can compare to a list of 'extra' work available and
assign by seniority. Can anyone guide me down the right path?
Click to expand...

It seems clear that you'll have to have the employees' seniority available
either in the Employee Table or a Table related one-to-one to the Employee
Table. You can create a Query to retrieve that data in Seniority order.

As you have not described details, I cannot say _how_ you would assign
employees to the proper extra work. If there is just a big "bucket" of
"extra work" and it's all the same, then you might use a form, with two List
Boxes or two Combo Boxes... one populated with employees in seniority order
and the other with extra work in whatever units you want to assign.

Larry Linson
Microsoft Access MVP
 
M

mc2computing

Well the function is this;
we have a list of charters that is put out weekly and dulled out by
seniority, and i want to be able to input the charters into a list and assign
them to employees by seniority. The trick is we have a couple hundred
employees and I will need to make provisions to start at the next person in
line. So lets say it stops at employee # 56, the next week needs to start
with #57. I have a few more ideas of how I would like it to work but just
getting started would help tremendously.

Thanks alot.
 
Top