You must set the "Refresh" option of your menu to "On Open".
-----Ursprüngliche Nachricht----- Von: Action Request System discussion list(ARSList) [mailto:[email protected]] Im Auftrag von Ravi Gesendet: Montag, 15. Dezember 2008 20:13 An: [email protected] Betreff: Re: AW: Using value from a SQL menu in another SQL menu's query Gary, Opela: thanks. the $fieldid$ worked. One thing I am noticing is that when I select customer and click on the devices, it shows the correct list of devices the first time. But when I change the customer, I keep seeing the same device list I saw the first time. Do I have to create a active link and perform something or can I set some property in the form so the device query is rerun everytime I change the customer? Thanks Ravi Martin, Conny wrote: > You should enclose the fieldid in $ not in % > > -----Ursprüngliche Nachricht----- > Von: Action Request System discussion list(ARSList) > [mailto:[email protected]] Im Auftrag von Opela, Gary L CTR USAF > AFMC 72 CS/SCBAH > Gesendet: Montag, 15. Dezember 2008 19:54 > An: [email protected] > Betreff: Re: Using value from a SQL menu in another SQL menu's query > > Ravi, try referencing the field ID of the txt_CUSTNAME, such as %536870914%, > in the SQL Query. You might have to work with it a little, I cannot think off > the top of my head using a field ID in a direct SQL menu, but I think it will > work. The menus don't see the field names, just the IDs. > > Thanks, > > Gary Opela, Jr. > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[email protected]] On Behalf Of Ravi > Sent: Monday, December 15, 2008 12:47 PM > To: [email protected] > Subject: Using value from a SQL menu in another SQL menu's query > > I have a form with two menus: customer and device. The customer menu > lists all the customers using a SQL (select distinct(CUST_NAME) from > ASSET order by CUST_NAME). I want the 2nd menu to list devices that > belong to that customer (select distinct(DEV_NAME) from ASSET where > CUST_NAME = 'txt_CUSTNAME' order by DEV_NAME). txt_CUSTNAME is the > name of the customer field in the form. This does not seem to be > working. How > > do configure the 2nd menu to use the customer the user selected from > the > > first menu item? > > Thanks > Ravi > > ______________________________________________________________________ > __ > _______ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: > www.rmsportal.com ARSlist: "Where the Answers Are" > > ______________________________________________________________________ > _________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > > ______________________________________________________________________ > _________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
