Re: Query Problems in Form Triggers

I have solved the first part of the problem with the use of cursors and such, but anyways, that is solved.

But I need help still with the second part. The main block here is CE_COST_ESTIMATION. The list item, PROJECT_ID, is the main item. There are 8 blocks under CE_COST_ESTIMATION. Each of these 8 blocks has its own copy of PROJECT_ID (the value is copied from the original in CE_COST_ESTIMATION). I would like to make it so that when PROJECT_ID is entered and validated, these 8 blocks are queried based on their PROJECT_ID in relation to :CE_COST_ESTIMATION.PROJECT_ID. Any ideas/solutions would be very much appreciated.

Greg Williams wrote:

> I have two blocks, let's call them block A and block B. They are joined
> by a 1:M relationship, Mandatory to Mandatory. One of the items in the
> B block, PROJECT_ID (varchar2(20)) is a list item. CODE is the main
> item for the entire form, and it is located in block A. Whenever
> someone enters in CODE, I would like the PROJECT_ID list to display the
> results of the query in the list. This is the first thing I can't
> figure out.
>
> There are also many other blocks under block B, all of them 1:M
> relationships (one block B for many underblocks). These are Mandatory
> to Optional. I would also like to make it so that once you enter in
> CODE and it queries and brings up the matching PROJECT_IDs, you can
> choose a PROJECT_ID from the generated list. Once you choose the one
> from the list, I would like the form to automatically query all of the
> underblocks based on the item picked from PROJECT_ID.
>
> I have the first part figured out to some extent, but I get errors when
> the query to CODE brings up no records (since the process I am using
> uses temp record groups). So it doesn't work that way.
>
> Any ideas? Please?
>
> Steve Karam
>
> Lambda Consulting
>
> steve-karam_at_lambdaconsulting.com
Received on Sat Dec 12 1998 - 20:21:41 CET