On Mon, 28 Feb 2005 10:55:03 -0800, George
wrote:

John - This will be a totally separate database. I just don't want to keep
updating two different databases whenever we get a new guardsmen joining our
unit.

Is there some way you can *link* from the Training database to the
personnel database, so that when you *do* update a person's name
(people do change their names, after all) or joins or leaves the
organization, that information is available?

If you're insisting on storing the same data redundantly in two
databases then you are creating the exact problem which you say you
wish to avoid.

John W. Vinson[MVP]