Brien, I would actually advocate that you not take this approach. Constantly mucking with User data can be a sore spot for performance and can also increase your risk of finding bugs in the internal ( and proprietary ) code for license management. Or even finding less known rules about how many times a user can be assigned a Fixed license in a short period of time. Yea, I know you said "anyone that I add to this group also needs a floating", but solutions like this (AR System applications) tend to be extended over time. You may later find that such an assumption may not hold true for the next version/feature request. However, a more general design will likely scale farther and I think actually be easier to implement too.
I would strongly suggest that you adopt the "other thought" from the start of this thread. Ref: From: Brien Dieterle <[EMAIL PROTECTED]> date: Mon, Sep 22, 2008 at 1:50 PM " I am strongly considering just abandoning the Field 112 anyway, and using an entire form just for storing the UserID to Parent. Then at least I can just loop over that form and forget about the field splitting... " If you manage these changes in a custom application then you can better detect triggering conditions and you can choose (as each trigger happens) if each change is important enough to do "now" vs "later" too. You could let managers add/remove users from ARS Groups and later propagate the change into the User's 'Group List'. HTH. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap.... Pick two. On Tue, Sep 23, 2008 at 11:44 AM, Brien Dieterle <[EMAIL PROTECTED]> wrote: > ** > Yes on trawling User table, I want to remove everyone from this group every > night and then add everyone back from the guide. > > I'll have to think about the trigger some more, but I think I want the guide > to trigger on modify so that if a new user is added to that field they are > added to the group immediately instead of only during the nightly sync. > > Thanks again for all your help! > > Brien _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
