Mike, Another way to skin this cat is to to the following:
Create a "child record" to the "parent record". The child will hold the "parent key" and one of many field 112 values for the "parent record". Then create a join (inner join of Parent form and child form based on the parent key) that pull all fields from the parent form except field 112. Pull the field 112 value from the child form. What you will find is that the field 112 value from the child will work as expected. And the join will let you have "multiple" field 112 values per parent record. Yes this means that your users need to interact with the join instead of the parent record directly, but that is a small price to pay for having the flexibility of multiple field 112 values. And you likely will want to mirror your Active Links from the Parent form to the Join form too. Your filters are not necessary to be mirrored as the normal Modify filters will be triggered if the user changes any fields from the parent form. HTMS (Hope that makes sense) HTH (Hope that helps) -- 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 7/4/07, Mike Balogh <[EMAIL PROTECTED]> wrote:
Jason, Thanks for the idea. I did look at the possibility of using computed groups. The problem is that one group of folks would need row-level access to a subset of records in the form, and a completely different group of folks would need row-level access to a different subset of records in the form. There is no overlap... one group cannot be allowed to see another group's records at all. As far as I'm aware, the only way to accomplish a security design like the one above is to use the Assignee Group field. And the Assignee Group field only accepts explicit groups. At least, that's what the documentation says. If anyone has experience otherwise, I'd be happy to hear about it. Thanks, ~Mike --- Michael J Balogh Wingspan Systems Inc. [EMAIL PROTECTED]
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
