I have a form which has a subform.In the main form I have only one
field (this is a drop down list and has a query attached to it) which
selects empno,Name from the EmployeeInformation table.
The sub form stores the time sheet data for each employee.When I am
able to do the timesheet data entry for the first record.But when I
select the second employee from the dropdown list and click on the
subform for entering the timesheet data, it says " The changes you
requested to the table were not succesful because they could create
duplicate values in the index,primary key or relationship.Change the
data in the field or fields that contain duplicate data, remove the
index or redifine the index to permit duplicate entries and try again"
Well,I am able to do data entry in the datasheet.Can anyone please
help me with solving this problem
Thanks