[AccessD] Never Take a job for a friend (Three level design question)

I think that some of the respondents so far kind of missed your
requirements, Joe (or perhaps the beer I'm enjoying for Canada has had more
effect than I anticipated).

You actually have only 3 meaningful user levels, since dispatchers are
powerless. The other three make a grid like this:

              Sup       Mgr       Exec
Sup          W         X            X
Mgr          R          W           X
Exec        R          R            W

Where R means Read, W means Write, and X means neither. If the user table
contained a 3-char column with each horizontal combination written as a
string (i.e. WXX, RWX and RRW) then the OnCurrent event can examine the
current row's notes field and act accordingly.

This demands of course that the Notes rows be tagged with UserLevel column
(S, M or E).

If a Sup is looking and the current Notes.UserLevel column contains M or E,
hide the Notes.
If a Mgr is looking and the current Notes UserLevel contains S, then
Notes.enabled = False; if the Notes UserLevel is E, then hide the Note.
If an Exec is looking, and the current Notes UserLevl contains S or M,
Notes.enabled = False, else Notes.Enabled = True.

I think that covers it.

hth,
Arthur


This problem will be much easier to deal with if the notes are presented in
single-form fashion rather than datasheet. That said,


On 6/30/07, Joe Hecht <jmhecht at earthlink.net> wrote:
>
> It is simple. Ya Right
>
>
>
> I am righting a poor mans HR program. There are four user levels.
> Dispatchers can not do notes, can not see notes. Field supervisor can
> write
> notes. Can not see manager or executive notes.  Managers can write notes,
> can read Field supervisor notes, not edit them or see executive notes.
> Executives can write theirs, see but not edit all other notes.
>
>
>
> Notes are many notes to one employee.
>
>
>
> How do I do notes so people see them in chronological order? If I do three
> sub tables how would I get all notes to same point. One employee can have
> multiple incidents good and bad in their record. How would I get all three
> levels of notes to same incident?
>
>
>
> Ya all know where I am spending my sat night.
>
>
>
>
>
>
>
> Joe Hecht
>
> jmhecht at earthlink.net
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>