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?
Answer Posted / 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 View All Answers
sql database suspect We have a sql database that is showing as suspect. How can we recover?
What is role playing dimension with two examples? : sql server analysis services, ssas
How do I perform an unattended install of sql server 2000?
what is package and it uses and how can u call a package
What are system databases in ms sql server?
what is a schema in sql server 2005? : Sql server database administration
List out what other servers you can use with ssrs?
How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication
Explain the categories of stored procedure?
Does index speed up select statements?
Can binary strings be used in arithmetical operations?
What are transactions in sql?
Do you know what guidelines should be followed to help minimize deadlocks?
In how many ways you can invoke ssrs reports?
Explain different types of self contained sub query?