Yes, you can design forms and workflow in such a way that they follow database normalization techniques. You can create an Assignment form whose sole purpose is to track the many to many relationship. I would highly recommend mapping it out in Visio or another tool first before you start doing anything in Remedy Admin, though.
(Embedded image moved to file: pic21520.gif)Countrywide James Van Sickle Remedy Developer IT - Remedy Development http://www.countrywide.com Robert Halstead <[EMAIL PROTECTED] COM> To Sent by: "Action [email protected] Request System cc discussion list(ARSList)" Subject <[EMAIL PROTECTED] [ARSLIST] Is relational database ORG> design doable in Remedy? 09/27/2007 10:38 AM Please respond to [EMAIL PROTECTED] RG Hey listeners, As we all know, a many to many table relationship in a database is a bad thing and the way to accomplish this correctly, in a database, would be to create an assignment table such that the ID's from the first table and second table are the only things stored. Is this possible to accomplish in Remedy? I am fixing our OLA violation workflow and need to modify the forms so that users may set their own. I came across this problem where, in our instance, a OLA Rule has 4 levels. Each level can have multiple groups assigned with multiple individuals per group. I would like to modularize this a little more in that group and the individuals are not copied again and again for each rule that wants to assign that group to them but instead have an "assignment table" to join the two. So I have a many to many relationship between Rules and Groups. I could have a many to many relationship on the Group -> Individuals as well, but lets just stay with Rules -> Groups for now as the solution (if there is one) will solve that problem. Is an "assignment table" possible in Remedy? Is this relational database design possible? Or do we just copy the data over and over again? -- "A fool acts, regardless; knowing well that he is wrong. The ignoramus acts on only what he knows, but all that he knows. The ignoramus may be saved, but the fool knows that he is doomed." Robert Halstead _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ====================================================================== Confidentiality Notice: The information contained in and transmitted with this communication is strictly confidential, is intended only for the use of the intended recipient, and is the property of Countrywide Financial Corporation or its affiliates and subsidiaries. If you are not the intended recipient, you are hereby notified that any use of the information contained in or transmitted with the communication or dissemination, distribution, or copying of this communication is strictly prohibited by law. If you have received this communication in error, please immediately return this communication to the sender and delete the original message and any copy of it in your possession. ====================================================================== _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
<<attachment: pic21520.gif>>
