Re: Want to Populate a list item

Jimbo wrote:

> Thanks for the reply Martin, I'll try and make my problem clearer now.
>
> 1. Yes you're right, I have two data blocks on one form in a master/detail
> relationship. The two data blocks are linked through a field called
> PURORDERNO.
>
> 2. I have attached a print screen of my form with this message, I have
> scanned it for viruses so if you wish to view it you can. If you do not wish
> to view it, I will try to explain. PURORDEREMP is the master block based on
> a table of the same name. EMPNO_LIST was just a text item with the numbers,
> but now it is indeed a list item and has property database item set to
> FALSE. It has the other two columns from the table.
> What you say about the PURORDER block is correct, just that it is based on a
> table called PURORDER.
>
> 3. There aren't a great many employees to appear in the list, so I think a
> poplist will be suited to the job. At the moment, I just want to populate
> the list with the numbers from the DB table but would prefer to have the
> names that these EMPNO's refer to. Didn't ask that because I just wanted to
> populate the list first and then deal with that problem. The problem with
> trying to get the employee's names in, is that they are stored in a separate
> table called EMP. The EMP and PURORDEREMP tables are linked through the
> EMPNO field. So to basically answer your question, I want the list to appear
> with the values e.g. "1111" as this is what is stored in the DB.
>
> Hope this helps you or anyone else.
> Once again thanks for the reply, Martin.
> James
>
> "Martin Doherty" <martin.doherty_at_nospam.com> wrote in message
> news:qllS9.14$iv4.101_at_news.oracle.com...
> > Jimbo, I need some clarifications before trying to help you:
> >
> > 1. 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?
> >
> > 2. 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.
> >
> > 3. 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.
> > >
> > >
> > >
> > >
> >

I'm jumping in late on this one but it seems to me that creating an LOV populated by a record group would solve the problem.

Daniel Morgan Received on Tue Jan 07 2003 - 17:19:26 CET