TMG-L Archives

Archiver > TMG > 2006-02 > 1138861966


From: David Ball <>
Subject: RE: [TMG] Reference field question
Date: Wed, 01 Feb 2006 22:32:46 -0800
In-Reply-To: <002401c627b0$ee9cf930$8200a8c0@tritowncomputers.com>


Matt,

I use the reference field for unique numbering of only people with the
surname of "Ball" either by birth, marriage or adoption (in my one-name
study, this is getting to be in the thousands). My only way so far to check
for duplication, or for where I left off numbering, is to sort the picklist
by the reference field and to scan down for obvious problems.

I have never tried to do a list of people with the reference number as the
primary sort that I could output to Excel and test for duplication (I use a
strictly numeric reference code, so this would be easy, but some
alphanumeric codes could be parsed in Excel and then sorted and tested), but
will need to figure one out when my database gets a lot bigger.

Dave

> -----Original Message-----
> From: Matt Goodrich [mailto:]
> Sent: February 1, 2006 8:27 PM
> To:
> Subject: RE: [TMG] Reference field question
>
> Thanks for the quick response everyone.
> I'll just have to careful. :-)
>
> > -----Original Message-----
> > From: Jim Byram [mailto:]
> > Sent: Wednesday, February 01, 2006 9:13 PM
> > To:
> > Subject: Re: [TMG] Reference field question
> >
> > Matt Goodrich wrote:
> >
> > > I just noticed, much to my dismay, that you can have 2 people with
> > > identical
> > > reference field codes. (alpha-numeric)
> > > Is this by design or am I missing a setting somewhere?
> >
> > The Reference field is a text field. You can enter whatever you wish.
> Any
> > sort of validation of your data to make sure you don't do that is up to
> > you.
> >
> > Jim
>
>
> ==== TMG Mailing List ====
> Visit the TMG Tips web site <http://www.tmgtips.com>; for items of interest
> to TMG users and links to other TMG related sites.


This thread: