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 |
is there a column to which a default can't be bound? : Sql server database administration
How to transfer an existing table from one schema to another schema in ms sql server?
What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio
hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail
List the data types available in mssql?
What are commonly used odbc functions in php?
What is the difference Between Sql-server 2000 & 2005
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?
How to convert a unicode strings to non-unicode strings?
can you any body tell me suppose database is suspect mode. how can take to normal?
What is difference between rownum and rowid?
what is the information that can be stored inside a bit column? : Sql server database administration