469,946 Members | 1,869 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,946 developers. It's quick & easy.

Form won't let me edit data!

Hi there all you smarter than me people!

I am stuck. I have been working on this database for days and cannot figure out how to solve my problem.

I have a form with two embedded subforms. The parent form contains patient identifiers, such as, medical record number, first name, middle initial, last name, physican name, etc. The first subform contains appointment information, such as, test results, procedures, counseling, etc. The second subform contains baby delivery data.

Each form/subform has a table as its control source. The parent table has the member record number (MRN) as it's primary key (no duplicates). The subforms has a database ID, autonumbered, as their primary keys.

I used DLookup to auto populate the controls on the parent form, using a query attached to an unbound control. However, I cannot save any changes on previously entered records. I receive the following error message: "The changes you requested to the table were not successful because thgey 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 want to be able to edit and add new records to the table.

Help!!!

Thanks.

Linda
Nov 2 '07 #1
2 5132
ADezii
8,800 Expert 8TB
Hi there all you smarter than me people!

I am stuck. I have been working on this database for days and cannot figure out how to solve my problem.

I have a form with two embedded subforms. The parent form contains patient identifiers, such as, medical record number, first name, middle initial, last name, physican name, etc. The first subform contains appointment information, such as, test results, procedures, counseling, etc. The second subform contains baby delivery data.

Each form/subform has a table as its control source. The parent table has the member record number (MRN) as it's primary key (no duplicates). The subforms has a database ID, autonumbered, as their primary keys.

I used DLookup to auto populate the controls on the parent form, using a query attached to an unbound control. However, I cannot save any changes on previously entered records. I receive the following error message: "The changes you requested to the table were not successful because thgey 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 want to be able to edit and add new records to the table.

Help!!!

Thanks.

Linda
Linda, I do not think that your problem can be diagnosed without a greater amount of information (Table Names, Primary Keys, Relationships, Record Source descriptions, etc.). If you are stuck, and you would be agreeable to sending me the Database as an E-Mail Attachment, I would be happy to look at it as soon as I get a chance. I simply cannot give a reply with the information provided, and even if I had the required information, analysis may still be difficult. You can wait and see if you like, and hopefully someone may have a solution, but if you would like me to look at the DB, just let me know and I'll send you my E-Mail Address in a Private Message. You could then send me the DB as an Attachment.
Nov 3 '07 #2
Linda, I do not think that your problem can be diagnosed without a greater amount of information (Table Names, Primary Keys, Relationships, Record Source descriptions, etc.). If you are stuck, and you would be agreeable to sending me the Database as an E-Mail Attachment, I would be happy to look at it as soon as I get a chance. I simply cannot give a reply with the information provided, and even if I had the required information, analysis may still be difficult. You can wait and see if you like, and hopefully someone may have a solution, but if you would like me to look at the DB, just let me know and I'll send you my E-Mail Address in a Private Message. You could then send me the DB as an Attachment.
Yes. I would definitely be interested in having some assistance with this problem. Please send me your e-mail address and I will send you the database. Thank you for your willingness to help!

Linda
Nov 3 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

5 posts views Thread by ortaias | last post: by
5 posts views Thread by mwilliams | last post: by
1 post views Thread by chromis | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.