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: [email protected] 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"
