Using value from a SQL menu in another SQL menu's query

[Ravi]

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"