I have created a subform where you select a vendor from a combo box and this then allows you to view all software of the selected vendor in a tabular view. When I use this form and then try to go into design view or close the form, i get the following error message:
'The changes you requested to the table were not successful because they would 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 redefine the index to permit duplicate entries and try again'
I have tried removing the index and changing the index to permit duplicates but this has not worked.
Could anyone tell me abit more about this error and how to get rid of it?
Many Thanks
'The changes you requested to the table were not successful because they would 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 redefine the index to permit duplicate entries and try again'
I have tried removing the index and changing the index to permit duplicates but this has not worked.
Could anyone tell me abit more about this error and how to get rid of it?
Many Thanks