You could also use select name from filter where schemaid in (select schemaid from arschema where name = 'formname') order by name;
to get a ordered list of filter names tied to your form in question.. Joe ________________________________ From: Norbert Bolmer <norb...@bolmer.de> To: arslist@ARSLIST.ORG Sent: Sun, October 18, 2009 10:13:05 AM Subject: Re: Menu to list flters of a form Hi Nitin, yes, use a SQL menu with following statement: select name from filter f, arschema s where f.schemaid = a.schemaid and a.name = 'formname' Br, Norbert Am 18.10.2009 um 16:04 schrieb nitin gogna: > ** > Hi ARlist, > > Is there any way to create character menu in which I can list the filters > related to a particular form? > > --With Warm Regards, > > Nitin Gogna _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"