Re: Filtering Records in SQL Forms 3.0

In article <40qsnu$m9e_at_sol.sun.csd.unb.ca>, Patrick McCarthy <pmccarth_at_rpc.unb.ca> wrote:
>
>
>I have created forms in SQL Forms 3.0 to list values from tables I have
>created on Oracle 7. What I need to filter out records when the form comes
>up. For example, I would like to list, in the form, only employees from a
>certain department.
>
>What is the command for doing this within the Form.inp file and where do I put
>it ?????
>

        You need to go back in sqlforms 3.0 and laod the form. The place where the list of values is specified. You can specify a query for look up for that field. In that query, specify, withyour "where" clause say what your deptt. you want to lookup from.

-- 
              _/_
 __.  ____  o /      
(_/|_/ / /_<_<__      |address:amit_at_mcs.com|