Re: Can one populate a POPLIST from a query in Forms 4.0? Newbie help required!

esuvl_at_csv.warwick.ac.uk (Richard James Tinker) wrote:

>Hi,

>I am fairly new to Oracle Forms V4.0. I want to populate a Pop-List
>from the query;
 

>i.e. SELECT name
> FROM middlenames
> ORDER by prescedence

>I would have thought that this was a fairly standard thing to do,
>but reading the Forms manuals (p 7-31), it describes entering
>(hard coded) values, but not populating the list from a query.
 

>I have a Form displaying user details, and want the poplist for
>peoples middle names, so that their first middle name is diplayed,
>and any other middle names are displayed (in order) when the user
>presses the pop-list button so the Names are listed thus;
 

> James []
> Arthur
> Smith
>Can anyone help?

>Richard
>--
>R.J.Tinker_at_csv.warwick.ac.uk

You should do this by using Record Groups. You can read all you need to know in the Developer's Guide Chapter 15.

It works fine....

Good luck

Kind regards ,

Rob Zoeteweij Received on Mon Mar 27 1995 - 09:55:06 CEST