Oracle Forms

Hi,
I have a form that we have display on a canvas. It has 2 block (both are database blocks - set to Yes). I have a master/detail relation set on the master block. I created a Relation with "Delete Record Behavior - Cascading, Prevent Masterless Operations - No, Deferred Coordination - No, Automatic Query - No.

When I open the form and click between records, the master / detail works fine.

In my top Master block, I have 2 items that are displayed on the canvas (both are non-base table block text items that have LOV's attached to them. Everything works great when I am in query mode on existing records. The detail block down below fires and requeries the block.

My issue is when I insert a record and select a value from the 2nd LOV item, I want it to query the Detail block below because the values I selected in the Master Block are needed in order to query the detail block down below. I have both values selected, however, it will not query down in the Detail block until I've clicked in the detail block and hit the "Run Query" execution.

I was wondering if there is a way to make this happen. I tried When-Validate-Item on the Master block LOV when on the 2nd LOV but I cannot issue a "GO_BLOCK(Detail-Block), and then EXECUTE_QUERY'. It displays an FRM message saying you cannot issue a "GO_BLOCK" in a when validate item.

I used to be able to do this when both fields were a "Poplist" List item but the problem is that we dynamically build the poplist and move the poplist item around depending on which record you were on. We had the poplist "Number of Items Displayed" set to 1 because we had a text item that showed behind it. Whenever you click on a record, we dynamically moved the item to the current record by capturing the X,Y position. I want to try to move make the text item block field the only field displayed on the form and eliminate that poplist list item overlaying it, eliminating the poplist altogether and getting rid of some issues I'm having with the dynamic building in 10g. Not to mention, I found a bug with the poplists.

Any ideas out there? I've exhausted mine.

Chris