There are lot's of ways to do this.

One way it's to compose your message with, for example, 'Letter +
Generator':

A - 1st Place
B - 2nd Place
C - 3rd Place

And your keys will be something like 'A1212', 'B7823'....

Another way it's to use a different field for the location. That way you
will have a different key composing the two fields (Location+Key).

Artur Anjos

----- Original Message -----
From: <zifnabbe@...>
To: <ib-support@yahoogroups.com>
Sent: Sunday, December 02, 2001 2:08 PM
Subject: [ib-support] Design database question


> Hi,
>
> I'm working on a database which now, will be used in several places,
> but not as a central database, but as a seperate database at every
> place. Within a few years, it is quiet possible that the seperate
> databases will merge into 1 (thus a central database). I use a lot of
> Autogenerated unique keys, but when the seperate databases will
> merge, the key will not be unique anymore... how can I avoid this?
> How can I design this database so it will be easy to merge into 1 at
> a later stage, but with the uses of an autogenerated key (thus a
> primary key of 1 field?)
>
> Thanks in advance,
> Tom.
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>