Suppose in a situation if two list boxes are there and if you select multiple o

Suppose in a situation if two list boxes are there and if
you select multiple options based on that the options
related to those selected items should display in second
list box.

Again if we select multiple items in second listbox then the
related to those selected items should display .

In this scenario how will you design database,tables?

Question Posted / swapna

1 Answers
4459 Views
HP, I also Faced
E-Mail Answers

Suppose in a situation if two list boxes are there and if you select multiple options based on that..

Answer / pawan k. dubey

e.g. create two table
1-department(dept_id int PK,dept_name)
2-employee(emp_id int Primary key,Name varchar(40),dept_id
FK)

now create two listbox employee and department.

step1-when multiple departments are selected...dispaly
employee related to selected department in employee listbox

step2-when multiple employees are selected...dispaly
respective department in department listbox

Is This Answer Correct ?

1 Yes

1 No

Post New Answer