Richard Broersma Jr wrote:
> But now that I think about it, using the authors suggestion (if it actually worked), how would
> would it be possible to change the active status from one badge to another?
>
Well, the check constraint as you wrote it requires that there always be
a badge listed as active for each employee. If you changed
the contstraint to: CHECK ( 2 > .....) then you'd be able to unset the
active status and then set a new one to active.
--
erik jones <erik(at)myemma(dot)com>
software development
emma(r)