Andy, Please explain what you mean by "Menu" ?
It sounds like your talking about a Set Field's "Pick List" window and not a menu to me. (But I might be wrong.) If I am on the right track... then what you need to do is make sure that the first Active Link sets fields to $NULL$ when no matches are found. This may require temp fields to be set from the set field actions and a third active link (that fires at a yet higher execution order) to copy the returned values back into the "right field(s)" if there is a value in the temp fields and then clear the temp field(s). Again.. If I am on the right track.... why not use a table field for this task instead of a "Pick List" window? Your workflow should refresh the table field pointed at "Form A", check if there were any records found, if not, then show the table for "Form B" and refresh it. It could again check and if no matches were found their... then do something else... ect... 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 Mon, Mar 24, 2008 at 3:20 PM, Mayfield, Andy L. <[EMAIL PROTECTED]> wrote: > Does anyone know of a way to have a menu populate from two difference > source forms? > > I need to have a search menu look for an entry from Form A, if there are > no matching entries look on Form B. I have been unable to figure out how > to have this done automatically. > I could have a selection field designating which source to look in > first, but I would prefer to have it done automatically. I tried > building two different AL's (one for each source form) and using a > larger Execution Order for the second source, but if the first one fails > the second does not appear to run. > > Andy L. Mayfield > Sr. System Operation Specialist > Alabama Power Company > Office: 205-226-1805 > Cell: 205-288-9140 > SoLinc: 10*19140 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
