FRM-40350 when querying child records a second time in master-detail form
I've got a query screen so that users can query child records without having to find the master record first. The query works fine the first time (i.e., login to form and immediately do a child query), but if I then go back to the query screen (both the master and child blocks are cleared at that time) and try to query again, I get a FRM-40350, even when performing the same query that was successful the first time.
The query parameters are passed in pre-query trigger that sets the default where clause of the detail block.
I have a master-detail relation set up between the master and detail blocks, Prevent Masterless Operations = no, Deferred = no and Automatic Query = no.
I've gone through the debugger multiple times, and the default where clause gets set correctly, I have no poplists in the detail form that may be filtering records. I'm thinking the culprit is in the master-detail relation program units, but I haven't modified those at all so don't know what to even look for.
Help?