how to start designing this database

S

skline

Hi there,
Can anyone suggest how I might set up a simple database to do employee time scheduling? All I need is names of employees [Names], [Days of the week] and [time] they a scheduled to work.

I need to tell the database not to schedule more than one person on one day - other than that it seems pretty straight forward set up.

Can anyone tell me how I might build this one requirement into the database?
 
J

Jeff Boyce

Without more details of the version of Access you are using, or your
experience designing/building database applications, I can only offer a
general suggestion:

Set a unique index on your schedule table, covering date and PersonID --
this will prevent more than one person on one date.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to implement two shifts per day with multiple teams 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Looking for a way to Force Successor Task to next workday IF 'x' amount of time left in workday 0
How to Shop Client delays in my ghantt chart so i can claim for delays 0
Avoiding Leads, using SVT, and Linking Tasks correctly 0
Employee Schedule not plotting properly - chart type / data series not correct 0
Level resource allocation error 1
Receiving unexpected Duration 0

Top