Welcome Guest. Sign in or Signup

2 Answers

Interview » Technical » Application Designer » Dependent Prompt Tables on Multiple Levels

Dependent Prompt Tables on Multiple Levels

Asked by: 3573 views Application Designer

You have a page with three levels. On level one you have a Prompt for Departments and on level two you have a Prompt for Employees. You are asked to design the page in such a way that after a user selects the Department on level one, the Employees Prompt on level two will show only employees of that particular Department. How would you achieve this functionality?

Related Questions

2 Answers



  1. srinu on Aug 08, 2012 Reply

    Write Peoplecode in departments field change event

    sqlexec(“select employee from leveltwo table where departments= levelone depatment field”)

    +4 Votes Thumb up 0 Votes Thumb down 0 Votes



  2. pavani.lankaa on Mar 09, 2014 Reply

    using dynamic view concept..

    -1 Votes Thumb up 0 Votes Thumb down 0 Votes


Answer Question

Click here to cancel reply.