Re: Populate Menu From Two Sources
Joe, I would do you one better and just build the join into the sql query. It would require that you would only need to update the query if anything changed and not have to modify the view. But that is just my way of looking at things. Brian Goralczyk On Mon, Mar 24, 2008 at 3:28 PM, Joe D'Souza [EMAIL PROTECTED] wrote: ** Andy, Create a join form or an SQL view of what you want, and create a search menu against that join form or a SQL menu against the SQL view that you create.. Joe -Original Message- From: Action Request System discussion list(ARSList) [ mailto:arslist@ARSLIST.ORG arslist@ARSLIST.ORG]On Behalf Of Mayfield, Andy L. Sent: Monday, March 24, 2008 4:21 PM To: arslist@ARSLIST.ORG Subject: Populate Menu From Two Sources 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 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Populate Menu From Two Sources
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
Re: Populate Menu From Two Sources
Andy, Create a join form or an SQL view of what you want, and create a search menu against that join form or a SQL menu against the SQL view that you create.. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Mayfield, Andy L. Sent: Monday, March 24, 2008 4:21 PM To: arslist@ARSLIST.ORG Subject: Populate Menu From Two Sources 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 No virus found in this outgoing message. Checked by AVG. Version: 7.5.519 / Virus Database: 269.21.8/1340 - Release Date: 3/23/2008 6:50 PM ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Populate Menu From Two Sources
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