e.g. create two table 1-department(dept_id int PK,dept

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 / pawan k. dubey

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

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

Please Help Members By Posting Answers For Below Questions

what are the different stages of Report Processing?

135

What is use of attribute hierarchy ordered ? : sql server analysis services, ssas

1007

Any one plz send me SQL Server Developer/DBA resume for 4 years experience

2740

What is the difference between primary key and unique constraints?

951

While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?

977

Will count(column) include columns with null values in its count?

1086

How to write a query with an inner join in ms sql server?

1038

What is a table called, if it has neither cluster nor non-cluster index? What is it used for?

1022

How to get a list of columns in a view using "sys.columns" in ms sql server?

983

Your table has a large character field there are queries that use this field in their search clause what should you do?

878

What is a field in a table?

1032

what are acid properties? : Sql server database administration

989

How to connect to a sql server using odbc_connect()?

1141

How many tables can be joined in SQL Server?

1054

What are magic tables in sql server?

1130