here's the correct one. select f.name from filter f,filter_mapping fm, arschema s where f.filterid = fm.filterid AND fm.schemaid = s.schemaid and s.name = 'formname'
Kind Regards Conny -----Ursprüngliche Nachricht----- Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Norbert Bolmer Gesendet: Sonntag, 18. Oktober 2009 16:13 An: arslist@ARSLIST.ORG Betreff: 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 > > _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the > Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"