When to use triggers or not

[fjm]

I have another question that I don't know how to answer. In my database I have a table with schedules. Each employee is assigned to one schedule. After thinking about this, I wonder what will happen if employee1 calls in sick and employee2 (Assigned to a completely different schedule) has to cover employee1's shift.

I think that the database should not allow employee2 to entered because remember, employee2 is assigned a totally different shift.

How should I go about fixing this? Should I use triggers for this?

Thanks,

Frank

[fjm]

I have another question that I don't know how to answer. In my database I have a table with schedules. Each employee is assigned to one schedule. After thinking about this, I wonder what will happen if employee1 calls in sick and employee2 (Assigned to a completely different schedule) has to cover employee1's shift.

I think that the database should not allow employee2 to entered because remember, employee2 is assigned a totally different shift.

How should I go about fixing this? Should I use triggers for this?

Thanks,

Frank

Hey guys, was my question that far out in left field? :)

[Atli]

Hey guys, was my question that far out in left field? :)

:)

I've never used triggers much, so I only know them in theory.

However.. I can suggest two solutions!

First: Don't assign each worker to a schedule. Assign each "login" (or whatever you call it) to a schedule. That way your workers can do a different schedule every day and your database has nothing to complain about.

Second: Don't allow your workers to change schedules! If one of them gets sick and somebody else needs to cover for him/her, have the substitute login as the first one and let them work the details out between them selves :)
(Caution, this method may cause extreme frustration, confusion and petty disagreements between your workers!)

[fjm]

(Caution, this method may cause extreme frustration, confusion and petty disagreements between your workers!)

Hi Atli,

Thank you for responding.. Ok. I will redo some of the relationships to reflect that. As far as the frustration goes, as long as it is directed between themselves, and I'm not present, its all good. :)

Frank