Hi
I have written a database for my recruitment company. For certain attributes, on which I need to search (Business Area, Skill, Role), I have created Subforms within the main Contacts and Candidate forms so I can assign a list of such attributes.
These are linked to "assignment" tables to allow a many-to-many relationshop. Eg: For Contacts I have a Roles Table containing the possible roles (Support, Developer etc) and a ContactRoleAssignment Table containing a ContactID assigned to a RoleID for each instance any specific role is assigned to a specific contact. I also have a Contacts table which contains other contact info like address etc.
This has been working find until recently. Now, when I try to add a new attribute to any of the aforementioned subforms I sometimes get the following error: "The LinkMasterFields property setting has produced this error: 'Ambiguous name detected: Add_record_Click'". This doesn't happen on all Contact records but most.
When I try to close the form I get the following error: "You cannot add or change a record because a related record is required in table: Contacts".
One thing I have altered recently is that I experimented with replication/synchronisation to see if it was an option. Since I produced a replica my database is now called a design master and the autonumbered ID fields have stopped going up logically and now have numbers such as 1304304 and -6759435 etc.
Any ideas what I can do?
BTW, is there a way to remove the replica status and take it back to how it was? I do have a old back up but there is a months worth of data on the new one. I import the new data as the replication function has added new fields to the tables.
Thanks in advance
I have written a database for my recruitment company. For certain attributes, on which I need to search (Business Area, Skill, Role), I have created Subforms within the main Contacts and Candidate forms so I can assign a list of such attributes.
These are linked to "assignment" tables to allow a many-to-many relationshop. Eg: For Contacts I have a Roles Table containing the possible roles (Support, Developer etc) and a ContactRoleAssignment Table containing a ContactID assigned to a RoleID for each instance any specific role is assigned to a specific contact. I also have a Contacts table which contains other contact info like address etc.
This has been working find until recently. Now, when I try to add a new attribute to any of the aforementioned subforms I sometimes get the following error: "The LinkMasterFields property setting has produced this error: 'Ambiguous name detected: Add_record_Click'". This doesn't happen on all Contact records but most.
When I try to close the form I get the following error: "You cannot add or change a record because a related record is required in table: Contacts".
One thing I have altered recently is that I experimented with replication/synchronisation to see if it was an option. Since I produced a replica my database is now called a design master and the autonumbered ID fields have stopped going up logically and now have numbers such as 1304304 and -6759435 etc.
Any ideas what I can do?
BTW, is there a way to remove the replica status and take it back to how it was? I do have a old back up but there is a months worth of data on the new one. I import the new data as the replication function has added new fields to the tables.
Thanks in advance
Last edited:
