I've got the following problem:
We want to duplicate 2 databases (A B) on a different location, each database must have write-access to his own databases.
We want to use even ID's for A, and odd ID's for B. So we can insert the info from the other database say once a day.
It's offcourse possible to insert each time an empty dummy, but when we use autonumber it will create empty gaps after a while.
So is there a function to autonumber just odd or just even ID's, or does someone has a better idea?
We want to duplicate 2 databases (A B) on a different location, each database must have write-access to his own databases.
We want to use even ID's for A, and odd ID's for B. So we can insert the info from the other database say once a day.
It's offcourse possible to insert each time an empty dummy, but when we use autonumber it will create empty gaps after a while.
So is there a function to autonumber just odd or just even ID's, or does someone has a better idea?