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"
