Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: populating a list item
Look into using record groups and LOVs. The LOV can be triggered from your
button with show_lov.
"drukqs" <invalid.drukqs_at_NOpandoraSPAM.belgie> wrote in message
news:Xns936CD375367CCinvaliddrukqspandora_at_195.130.132.69...
> Hi
>
> I want to make a form where I can make orders. If I click a button ("Make
> new order") I must be able to fill in a few fields (quantity, name, ...).
> But I have to be able to choose the name of a customer from a list. So it
> has to be sort of a db list (I hope I am clear enough here). I was
thinking
> on a query like this:
> select name
> into :cust.list
> from customers;
> I put this in a trigger (when new block instance). But it says there must
> be ellements defined in the list. Where do I need to put my query? Or am I
> doing things completely wrong here?.
> Thx
Received on Tue Apr 29 2003 - 15:28:33 CDT