G
Guest
Here is the problem:
I have a main form with a combo box to choose client.
A subform displays all events relating to the chosen client.
For ONLY ONE of those clients, I am allowed to edit data in the subform.
For the rest I get the error msg "The changes you requested to the table were
not successful because they would create duplicate values in the index,
primary key or relationship."
The only thing that separates the ONE client's events (that I can edit in
the subform) from the others, is that is the first in the list. Otherwise it
should operate no differently from all the other clients.
RELATIONSHIPS: My Client table (mainform) has a 1 to many relationship with
the event table (subform).
INDEXES:
My client field in the client table is indexed: Yes (No Duplicates)
My client field in the events table is indexed : Yes (Duplicates OK)
PRIMARY KEYS:
Client table: Client
Event table multifield Primary key (not including client)
All the Primary Keys are required fields and so are filled in on all
records. The link child / master fields are identified in the properties of
the subform (Client). The linking field (client) is populated on both forms
and there is a control on the main form and the subform with the values held
in it. I have researched this on the web and there seems to be a bug in
Access 2003 with this error msg but I am using Access 2002.
Perhaps the problem is because my Primary key in the Event Table is
[ProposalNo] + [EventNo] both indexed as duplicates OK, although obviously
each combination is unique. Could the subform object to both being indexed
as duplicates OK?
I can manually add onto the table for all clients, so the problem must be in
the form/subform. Is there something I am missing to do with the fact that
the first client in the list (ie the one which the combo box defaults to
showing upon opening the form) can be edited and the others cannot?
PLEASE HELP!!!!!
Thank you!!
I have a main form with a combo box to choose client.
A subform displays all events relating to the chosen client.
For ONLY ONE of those clients, I am allowed to edit data in the subform.
For the rest I get the error msg "The changes you requested to the table were
not successful because they would create duplicate values in the index,
primary key or relationship."
The only thing that separates the ONE client's events (that I can edit in
the subform) from the others, is that is the first in the list. Otherwise it
should operate no differently from all the other clients.
RELATIONSHIPS: My Client table (mainform) has a 1 to many relationship with
the event table (subform).
INDEXES:
My client field in the client table is indexed: Yes (No Duplicates)
My client field in the events table is indexed : Yes (Duplicates OK)
PRIMARY KEYS:
Client table: Client
Event table multifield Primary key (not including client)
All the Primary Keys are required fields and so are filled in on all
records. The link child / master fields are identified in the properties of
the subform (Client). The linking field (client) is populated on both forms
and there is a control on the main form and the subform with the values held
in it. I have researched this on the web and there seems to be a bug in
Access 2003 with this error msg but I am using Access 2002.
Perhaps the problem is because my Primary key in the Event Table is
[ProposalNo] + [EventNo] both indexed as duplicates OK, although obviously
each combination is unique. Could the subform object to both being indexed
as duplicates OK?
I can manually add onto the table for all clients, so the problem must be in
the form/subform. Is there something I am missing to do with the fact that
the first client in the list (ie the one which the combo box defaults to
showing upon opening the form) can be edited and the others cannot?
PLEASE HELP!!!!!
Thank you!!