I need to update prompt table before they push prompt button
I would like to update prompt table on the field before they push the prompt button.
I have two prompt tables - on for job opening, one for person id. If I update the job opening field (which has a prompt table) I want the list of person ids for that job opening in the prompt table for the person id to be changed.
The problem is if I select the job opening using the prompt table an event is triggered and I can update the person id prompt table. If I just type the job opening value in the field no event is triggered so I can not update the hrs_person_id prompt table. They want me to remove the field if this can't work. It would be lovely to have the hrs_person_id field and to have the prompt table properly display the person ids for the job opening that is typed in on the page