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"
