usmc-ratman
Registered User.
- Local time
- Today, 12:02
- Joined
- May 27, 2005
- Messages
- 20
Need assistance quickly.... please
Have a main table with client personal information (name, dob, address, etc), then 5 additional tables (file notes, charting, billing, etc) that are linked to that main client table.
The main table (named "clients") has a PK set that is autonumber, no duplicates, unique. The linked tables all have PK's set, that are also autonumber, no duplicates, unique; and then a linking field to link it to the clients table. There is a main clients form, with 6 tabs, each tab contains a subform for each of the linked tables.
There are 13 users on the system, and all 13 are usually using the database throughout the day. The database is split between frontend / backend, with the BE residing on a shared 1TB network server drive.
Recently, they are getting the error (when entering in the billing tab) that "the record cannot be created because it would create a duplicate in an index field" or something similar to that. I assume this is happening because two or more users are entering billing information at the same tab, but never in the same clients record, just entering data into the same table at roughly the same time.
How can I stop this from happening, short of creating an independant popup form for the billing.
I have tried to figure out a way to have the subform "hold" the new entry until they tab through the record completing the record information, and then adding it into the billing table, but as of yet havent figured out how to do that. Something to do with an INSERT INTO command...
Thanks,
JR
Have a main table with client personal information (name, dob, address, etc), then 5 additional tables (file notes, charting, billing, etc) that are linked to that main client table.
The main table (named "clients") has a PK set that is autonumber, no duplicates, unique. The linked tables all have PK's set, that are also autonumber, no duplicates, unique; and then a linking field to link it to the clients table. There is a main clients form, with 6 tabs, each tab contains a subform for each of the linked tables.
There are 13 users on the system, and all 13 are usually using the database throughout the day. The database is split between frontend / backend, with the BE residing on a shared 1TB network server drive.
Recently, they are getting the error (when entering in the billing tab) that "the record cannot be created because it would create a duplicate in an index field" or something similar to that. I assume this is happening because two or more users are entering billing information at the same tab, but never in the same clients record, just entering data into the same table at roughly the same time.
How can I stop this from happening, short of creating an independant popup form for the billing.
I have tried to figure out a way to have the subform "hold" the new entry until they tab through the record completing the record information, and then adding it into the billing table, but as of yet havent figured out how to do that. Something to do with an INSERT INTO command...
Thanks,
JR
, i thought about changing the PK to a text field (since there will not be a number constraint that could cause it to error out) and make the default value the date/time (ie: =format(now(),"mmddyyhhmmss"). I've tested this, and it gives a unique number value, and the users would have to be going to enter a billing record at exactly the same second, which isnt impossible, but less likely than not.
