Blue
White
Purple
Green
Red
Orange
Blue Light
White Light
Purple Light
Green Light
Red Light
Orange Light
I have table emp_info with the following detailsemp_id (int) PKem_Name (varchar)C_NO (int)When I view the record it shows the individual record on the basis of emp_id. for exampleBy view the record of the employeesemp_info.asp?editid1=1I want to view the record on the basis of C_NO. How should i can display the employee details on the basis of C_NO.
On the Table tab, click the Add View button and create another view of the data. You could also make a detail/child connection to another table field. This way you could display the data in both ways.