I am currently developing two database, one in Ms Access and the other in Lotus Notes. This question I belive should be independent of language though.
The two database are both multi-site, with replication occuring every hour (or so). Users at each site are able to create records, one of which has a field that needs to be sequential and unique. That is the database records Action Items across multiple sites, and each AI must have a unique sequential number (this is in additon to a hidden primary key, that is set as a replication ID).
What is the best way to achieve this. The only method I have thought of that would enable this, is to have this number calculated on the fly, based on a date/time field, that records the time the record was created. Thus, I would count all the records created before the current one, add 1, and get the unique sequential number. The only problem is that this is really slow.
Can anyone else suggest how else this may be done?
The two database are both multi-site, with replication occuring every hour (or so). Users at each site are able to create records, one of which has a field that needs to be sequential and unique. That is the database records Action Items across multiple sites, and each AI must have a unique sequential number (this is in additon to a hidden primary key, that is set as a replication ID).
What is the best way to achieve this. The only method I have thought of that would enable this, is to have this number calculated on the fly, based on a date/time field, that records the time the record was created. Thus, I would count all the records created before the current one, add 1, and get the unique sequential number. The only problem is that this is really slow.
Can anyone else suggest how else this may be done?