Re: Want to Populate a list item -> to be continued in comp.databases.oracle.tools

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:DklS9.13$iv4.58_at_news.oracle.com...
> P.S. let's switch the discussion over to comp.databases.oracle.tools, it
> is the appropriate forum and might put your question in front of some
> more of the 'right' people.
>
> Martin
>
> Martin Doherty wrote:
>
> > 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.
> >>
> >>
> >>
> >>
> >
>
Received on Tue Jan 07 2003 - 06:06:29 CST