DJK(John) Robinson
djkr at msn.com
Sun Jul 1 05:07:03 CDT 2007
Hi Joe, Not sure I fully understand the setup, but here goes. Since your question is about ordering the seeing of notes, I presume you already have some access control in place, so that the system knows whether the current user is D,S,M or E (Dispatcher, Supervisor, etc). I'd probably put all the notes in one table, with each record time-stamped on creation, and identified by employee and creator-type (S,M or E). Then querying can exclude records that the current user shouldn't see, and order on the creation time-stamp. If for some reason you *have* to have separate tables, then still time-stamp records on creation, but use an appropriate union query to bring together the right set for the current user. Or have I misunderstood something? John -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Joe Hecht Sent: 01 July 2007 00:08 To: 'Access Developers discussion and problem solving' Subject: [AccessD] Never Take a job for a friend (Three level designquestion) 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