Re: Needing to know how to use LOV's in Oracle Forms 6.1

"Neville Sweet" <sweet.neville.nj_at_bhp_xxremovexx_.com.au> schrieb im Newsbeitrag news:9jlh34$r3m$1_at_gossamer.itmel.bhp.com.au...
> Parish,
>
> Define a Record Group, selecting the database values to be displayed in
 the
> LOV.
> Then create an LOV and base it on that Record Group.

But be sure that the Record Group returns two character values. Otherwise it won`t work.

> Parish wrote in message ...
> >I am trying to make a list of values (or something similar if you know
> >of a way) that will allow a list of values to be automatically
> >populated by data that is already in the database. For example: if I
> >am tracking a particular company and several of the contacts that work
> >for that company, how do I select the one contact that I want (so that
> >his/her information is displayed) so that the fields (like phone,
> >email address, fax number, and whatever else that is personal to that
> >contact) are populated?

Use the WHEN-LIST-CHANGED Trigger on the LOV field to query the fields for email, phone and so on...

So long,

Jan Received on Wed Jul 25 2001 - 09:14:10 CEST