Hello,

I was wondering if anybody out there knows of how to create a prompt table edit that will dynamically create a search list.

For example, I have a page with a DEPTID field (w/ prompt button). When the user presses the prompt button, I want the prompt table to be the JOB table, but with the additional criteria that the SUPERVISOR_ID = %EmployeeID (EMPLID of current user).

I looked at dynamic views but that only lets you dynamically control what the prompt table will be.

I looked at using a query view as the prompt table (and specifying SUPERVISOR_ID as a prompt in the query), but that leaves me at square one where I won't be able to dynamically pass in the MANAGER_ID.

Thoughts, anybody?

Thanks.