Create an active link that runs on menu/row choice on the first menu, and set it to refresh the menu on the second field. This should cause it to function properly.
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 1:13 PM To: [email protected] Subject: 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"
