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?



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

More SQL Server Interview Questions

is there a column to which a default can't be bound? : Sql server database administration

0 Answers  


How to transfer an existing table from one schema to another schema in ms sql server?

0 Answers  


What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio

0 Answers  


hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

0 Answers   IntraLogic, Oracle,


List the data types available in mssql?

0 Answers  






What are commonly used odbc functions in php?

0 Answers  


What is the difference Between Sql-server 2000 & 2005

3 Answers   Value Labs, Wipro,


As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?

0 Answers  


How to convert a unicode strings to non-unicode strings?

0 Answers  


can you any body tell me suppose database is suspect mode. how can take to normal?

2 Answers   Teledata,


What is difference between rownum and rowid?

0 Answers  


what is the information that can be stored inside a bit column? : Sql server database administration

0 Answers  


Categories