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"

Reply via email to