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
Explain cross join or cartesian product in sql?
What is sub query and its properties?
Define views.
whats new about truncate in sql server 2008?
Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?
How to copy the tables, schema and views from one sql server to another?
Difference between connected and disconnected database in .net with sql server?
Can sql servers linked to other servers like oracle?
Can I work with several databases simultaneously? : sql server management studio
Write query to return all rows sql?
Tell me about builtinadministrator?
after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?
what are candidate key, alternate key and composite key? : Sql server database administration
What is trigger and different types of Triggers?
How do you manipulate data?