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 - 13:27:00 CST