Michael, Just my two cents....
I would give the users a but that says... "add multiple billing areas from this state" and have it open another dialog. That dialog would have a table field and the user would be able to "Select all" or select a sub set of the records in the table field. Then a button that says "Create records for selected Billing Areas" that loops over the selected records in the table and closes the dialog. That allows the user to see that there are really 1500 Billing Areas in that State before you go off and create 1500 records. But it still allows them to do just that when it is really needed too. It also gives you a shot at telling the user things like... "You selected more than 50... are you really sure? (Note this will take a while so be patient after you say 'Yes'.)" But in general table looping is the way I would go with such an activity. 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 9/26/07, McManus Michael A SSgt HQ 754 ELSG/DOMH <[EMAIL PROTECTED]> wrote: > ** > Listers, > > I have a requirement to allow users to add multiple billing > areas to a change request. Currently, they click a button called Add > Billing Area, which opens a dialog called Change Bill Area. The user > selects a billing area id from a character field with a menu attached which > fires a push fields that creates a record in the Change Bill Area form. > I've added the ability for the user to select via billing area name, state, > center and division in addition to ID but what I'd like to do, is allow > users to select a state (or division, etc.) from that drop down, and then > create a request for every billing area in that state. I'm sure I'll need > to loop through that results set somehow, but I'm unfamiliar with that type > of workflow in Remedy. Any help is greatly appreciated. > > > > ARS 6.3, SQL 2K, and Server 2000 > > > > Thanks much, > > > > Michael A. McManus, SSgt, USAF > > Remedy Developer > > HQ 754 ELSG/DOMH > > DSN: 596-6478 / Comm: 334-416-6478 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"

