I have several forms where we update students information.We have a form that allows users select the name of the student in a combo box.The drop down list consists of student name,course,year in a single row.
The problem is that there are duplicates comming up in the dropdown list. like the same student information is duplicated 3-5 times.and bcoz of that the drop down list has increased to 9000rows.
I have also checked the background query that is working to get the list of student information in the combo box but even the query is showing duplicate rows,thought the source table doesnt have any duplicates in it.
Its been working well and all these days but some how this problem has arised and causing hinderance at workplace.
Please reply with a possible solution.