I am running oracle forms 12c I have a client_id, client name, and contact number fields where if I type client_id it gets the clients name and contact number and those fields get populated

but when I execute_query I mean press ctrl+F11 I do not get those fields populated I have to manually press the tab key from the client_id field to get those populated

This is when I create a new record enter image description here

This is when I execute the query enter image description here

By the way, it is a master detail form and the same is happening it's not getting the product name and pcs

How do I get those please help

1 Answer 1


You should use the "post-query" trigger on record level and fill in those fields.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.