Shift Bid Selection

[Guest]

So I'm starting a new project, and I'm not quite sure how to begin.

My objective is to create a database that will include emplyees, their
seniority and their bid from a selection of shift options. What I would like
to do with the database is to filter their selections based on seniority and
assign most preferred shift based on availablity. I want to set up my project
properly so I'm open to any suggestions, including table structure. Thanks in
advance for any assistance!

 

[Guest]

Ok,

So here is an update. I have decided on what I believe to be an appropriate
table structue. I have three tables each with the following fields:

Employee Information
Employee ID
Empoyee Name
Empyee Rank
Shift Information
Shift ID
Shift Description
Shift Openings
Shift Bids
Employee ID (related to employee ID in Empoyee Information Table)
Shift ID (related to Shift ID in Shift information Table)
Bid Rank

Now all I need to do is figure out how to write a query that will assign a
shift based off of rank, preference (same as bid rank) and availability (as
determined by shift openings). Thanks to all who may actually read this and
offer assistance!