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 / 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 |
How to test a dml trigger in ms sql server?
What is the status of services on passive node for failover cluster in sql server? : sql server database administration
What are date and time data types in ms sql server?
What protocol does sql server use?
What are user-defined functions (udfs) in sql server?
What is difference between rownum and row_number?
what is the different types of backups available in sql server? : Sql server database administration
what is sql injection?
How much is a sql server license?
What is a table called, if it does not have neither Cluster nor Non-cluster Index?
How do you size a resultset?
What are the filtered indexes?