I have already posted this problem without getting any resolution. I have had posted a working solution but unfortunately the reasons why the suggestions were made are beyond my understanding. Any help preserving my sanity would be appreciated!
I have three tables consisting of:
1. A member table
System assigned primary key
Member Number, indexed, no duplicates
Member Name
2. Groups table
System assigned key
Group Code, indexed, no duplicates
Group Name
3. Group members
System assigned primary key
Group System Assigned Key
Members System Assigned Key
NB composite index defined on last two fields, no duplicates allowed
Forms
1. Members, allows input of member number and member name
2. Groups, allows input of group code and name
Database relationships
Members linked to Group members, one to many, enforce referential integrity
Groups linked to Group members, one to many, enforce referential integrity
Using wizards, I created a Groups form with a GroupMembers subform.
All very simple, as simple as one could ever get in a database design.
However, I cannot ever get the subform to accept new entries, i.e. to add a member to a group. I get a message saying that the record cannot be entered since duplicate record, index or similar will occur. When I open the GroupMembers table in datasheet mode and add records, (having listed out the System Assigned keys and manually input them) I can use the Groups/GroupMembers subform to list all the members I have input via the datasheet mechanism.
I next tried removing the Autonumbered link fields on the GroupMembers table and replacing then with the actual group code and members number. Once again I could create entries via a datasheet bout this time the subform would not allow any data entry.
:banghead::banghead::banghead::banghead::banghead::banghead::banghead::banghead:
Who can talk me through how to achieve my goals?
My final object is now to have a main/subform to allow entry of members into groups via a tabular subform. I would like to input a member number and for the system to reflect back to me the name to confirm correctness.
It's not much!
I have three tables consisting of:
1. A member table
System assigned primary key
Member Number, indexed, no duplicates
Member Name
2. Groups table
System assigned key
Group Code, indexed, no duplicates
Group Name
3. Group members
System assigned primary key
Group System Assigned Key
Members System Assigned Key
NB composite index defined on last two fields, no duplicates allowed
Forms
1. Members, allows input of member number and member name
2. Groups, allows input of group code and name
Database relationships
Members linked to Group members, one to many, enforce referential integrity
Groups linked to Group members, one to many, enforce referential integrity
Using wizards, I created a Groups form with a GroupMembers subform.
All very simple, as simple as one could ever get in a database design.
However, I cannot ever get the subform to accept new entries, i.e. to add a member to a group. I get a message saying that the record cannot be entered since duplicate record, index or similar will occur. When I open the GroupMembers table in datasheet mode and add records, (having listed out the System Assigned keys and manually input them) I can use the Groups/GroupMembers subform to list all the members I have input via the datasheet mechanism.
I next tried removing the Autonumbered link fields on the GroupMembers table and replacing then with the actual group code and members number. Once again I could create entries via a datasheet bout this time the subform would not allow any data entry.
:banghead::banghead::banghead::banghead::banghead::banghead::banghead::banghead:
Who can talk me through how to achieve my goals?
My final object is now to have a main/subform to allow entry of members into groups via a tabular subform. I would like to input a member number and for the system to reflect back to me the name to confirm correctness.
It's not much!
