TheSearcher
Registered User.
- Local time
- Today, 03:36
- Joined
- Jul 21, 2011
- Messages
- 304
Hello All,
I have a program in which users create progress notes for clients with disabilities. When they begin writing a new note a Note_Id is assigned to it. This along with the client’s basic infoformation is then appended to a table called tbl_BasicInfo.
Also, for each new note, five goals specific to that client are appended to the tbl_Goals table via an Insert query. Tbl_Goals has an autonumber as a primary key.
Occasionally, when the five goals are appended each one is duped on tbl_Goals (even though it has an autonumber as a primary key). The seeding of the autonumber is correct. I have code that checks this.
So, the two issues are:
• Autonumber primary key allows dupes.
• After the dupes are allowed the primary key disappears.
I resolve the immediate issue by deleting the dupes, recreating the primary key and compacting the database.
Does anyone have any ideas on why an autonumber primary key would allow dupes?
Example of dupes on tbl_Goals:
Thanks in advance for your help!
TS
I have a program in which users create progress notes for clients with disabilities. When they begin writing a new note a Note_Id is assigned to it. This along with the client’s basic infoformation is then appended to a table called tbl_BasicInfo.
Also, for each new note, five goals specific to that client are appended to the tbl_Goals table via an Insert query. Tbl_Goals has an autonumber as a primary key.
Occasionally, when the five goals are appended each one is duped on tbl_Goals (even though it has an autonumber as a primary key). The seeding of the autonumber is correct. I have code that checks this.
So, the two issues are:
• Autonumber primary key allows dupes.
• After the dupes are allowed the primary key disappears.
I resolve the immediate issue by deleting the dupes, recreating the primary key and compacting the database.
Does anyone have any ideas on why an autonumber primary key would allow dupes?
Example of dupes on tbl_Goals:
ID_PrimaryKey | Task_No | Note_Id | Client_Name | Goal | Assistance_Needed |
41479 | 1 | 6451 | Mr. Client | Effective Communication/Self-Confidence | Leading Questions |
41479 | 1 | 6451 | Mr. Client | Effective Communication/Self-Confidence | Leading Questions |
41480 | 1 | 6451 | Mr. Client | Functional Memory | Verbal Instructions |
41480 | 1 | 6451 | Mr. Client | Functional Memory | Verbal Instructions |
41481 | 1 | 6451 | Mr. Client | Information Processing/Following Verbal Directions | |
41481 | 1 | 6451 | Mr. Client | Information Processing/Following Verbal Directions | |
41482 | 1 | 6451 | Mr. Client | Planning | |
41482 | 1 | 6451 | Mr. Client | Planning | |
41483 | 1 | 6451 | Mr. Client | Problem-Solving/Decision-Making | Leading Questions |
41483 | 1 | 6451 | Mr. Client | Problem-Solving/Decision-Making | Leading Questions |
Thanks in advance for your help!
TS