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"
