L
Learning Access
I have a main form called Faculty Details that I want to insert a subform
into under a tab I have named Employment Information. I want to pull fields
from my main table called TblEmployeeCoverPage. The following fields I want
to pull: Appointment, Status, Education and Higher Education/Cert/Degree. I
can get a subform to populate under this tab in the main form however, it
will not allow me to save the history of changes that an employee can have
without an error that says: 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 fields that contain duplicate
data, remove the index, or redefine the index to permit duplicate entires and
try again. " I went into the indexes to make duplicates possible but this
doesn't work.......any suggestions?????
into under a tab I have named Employment Information. I want to pull fields
from my main table called TblEmployeeCoverPage. The following fields I want
to pull: Appointment, Status, Education and Higher Education/Cert/Degree. I
can get a subform to populate under this tab in the main form however, it
will not allow me to save the history of changes that an employee can have
without an error that says: 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 fields that contain duplicate
data, remove the index, or redefine the index to permit duplicate entires and
try again. " I went into the indexes to make duplicates possible but this
doesn't work.......any suggestions?????