Hi All,
I have a Job Tracking application (Access 2003) which has a custom Primary Key on the Job table. When a new Job record is created, the code fetches the next available Job Number from a parameters table and allocates it to the Job record. Then when the new Job record is saved, the Job Number in the parameters table is incremented. This works fine in a single-user environment or in a multi-user environment where only one person ever enters new Jobs, which up until now has been the case. However, the client now wants to be able to enter multiple new jobs simultaneously and clearly the way the application currently allocates Job Numbers will not accommodate this.
I can think of various ways of doing it, but none of them are very elegant, so I'd be grateful for any suggestions or pointers to any good articles.
TIA,
Andrew
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (1) |
Tidak ada komentar:
Posting Komentar