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