Re: Want to Populate a list item
Date: Mon, 06 Jan 2003 12:01:03 -0800
Message-ID: <qllS9.14$iv4.101_at_news.oracle.com>
[Quoted] [Quoted] Jimbo, I need some clarifications before trying to help you:
- You make ambiguous use of the word 'form'. A form is an fmb file, and contains one or more blocks. I think when you say "master and detail forms", you mean "master and detail blocks"? It is dead easy to link blocks in one form, a lot trickier to link blocks in two separate forms! I'm guessing you are just working on the one form?
- I'm not sure what is in each of your blocks. Are the following assumptions correct? - PURORDEREMP is master block based on Order Header table, contains EMPNO_LIST (control item with property Database Item = False) along with relevant columns of Order Header table (Database Item = True). - PURORDER is detail block based on Order Details table, related to PURORDEREMP block via PURORDERNO item.
- How many employees could potentially appear in the poplist? How do you want the poplist entries to appear? e.g. "Doherty, Martin - 35998" or "35998 - Doherty, Martin" or "Doherty, Martin" or "35998"? I expect that in any case, 35998 will be the actual item value to be used in querying the Order Header table. If the number of employess is large, maybe a poplist isn't the best choice of UI element.
Thanks
Martin
Jimbo wrote:
>I have created a master/detail form with the master data block being
called
>PURORDEREMP and detail PURORDER. On the master form I have a list item
>(poplist) called EMPNO_LIST and I want to populate this but am unsure how.
>
>On the master form I want the user to click on EMPNO_LIST and select an
>employee number and the orders that this employee has made will appear in
>the tabular detail form.
>
>The master and detail forms are linked through a field called PURORDERNO.
>
>I am using Oracle 9i. Anyone know how I can do this? I have been
trying and
>searching the Internet all day without success.
>
>
>
>
Received on Mon Jan 06 2003 - 21:01:03 CET