Arthur Fuller
fuller.artful at gmail.com
Sun Jul 1 12:07:49 CDT 2007
Minor addendum, perhaps obvious. If a dispatcher is looking, hide the Notes, period. Arthur On 7/1/07, Arthur Fuller <fuller.artful at gmail.com> wrote: > > 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 > > > >