Chris, Although I think Axton's would likely perform better and be more maintainable in the long run too. Another option could be similar to Axton's idea... but...
Build a DB join of the current form and the "other form" using the "IN" operator at the DB level. Then the Table field qual could be "static" and based only on the current records 'Request ID' value. The DB join would be something like... Select a.C1, a.C2, ....(etc) from T123 a, T345 b where b.C44444 IN a.C1234567 Where: A = your current form B= a form with one record per value in the field in question C44444= the value in form B that holds the individual values in the list of values in form A's field C1234567. Just a thought. -- 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 3/5/07, Axton <[EMAIL PROTECTED]> wrote:
you can create a table field that points to something the data can reference, then turn that comma separated list into an external qual, then walk that table to create the records. For example, if your field contains companies, you may have a value like this: BMC,HP,Sun If you have a company table, point a table field at it, then convert that list to an external qual using the replace function: 'Company' = "BMC" OR 'Company' = "HP" OR 'Company' = "Sun" Then you can walk the table with a filter or active link guide. Axton Grams On 3/5/07, Christopher Gillman <[EMAIL PROTECTED]> wrote: > ** > > > Listers, > > > > I'm playing around with some data, and have checked the KB, and have asked > several people about this but can't seem to find the correct answer. I know > that it's possible to do in Remedy, but it's been so long since I've fooled > around with it, I can't remember how to do it. > > > > What I'm trying to do is take a record that has multiple fields which > contain multiple strings of data, delimited by a comma ",". For example: > Hi1, Hi2, Hi3, Hi4, etc. Is there a function or process that can be used to > parse these into their own records? I.e. Record1 = Hi1 Record2 = Hi2 > Record3=Hi3 etc. > > > > Or, as a second option, is there a way to create a table, which lists these > as separate records without manipulating the data? > > > > As always, help is appreciated! > > > > Chris
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
