Tracking form

[Sherry]

I'm looking for a tracking form that I can use to determine who I have
specific records on. All the ones I've found show what records I have
for a person or family, but I'd like to go the other way also.

I'd try coming up with something in Access myself, but before I took
the time to re-invent the wheel, I was wondering if someone already had
come up with something like this.

For example, I've printed off a bunch of WWI Draft Registration forms.
I'd like to track which ones I've printed off and ideally, have tables
linked so that I can look at an individual in the database to see what
I have on that individual Does ths make sense?

I've only dabbled with Access in the past.

Last night I sorted through my piles on the floor in order to get ready
to start a new database in my genealogy program. I decided that it's
probably better to start over from scratch than to try to clean up the
mess I have now. While I was sorting, I thought it would be nice to
know just what I have while I'm doing the data entry because I'm always
popping into Ancestry or other web sites and finding stuff... a quick
look would tell me if I've already got it or not! I think once I get
all my people re-entered. Fortunately, it's not a huge database, only
about 1500 individuals right now.

I suppose we all can say "I wish I knew then what I know now" <rbg>

Thanks,
Sherry

[Paul Blair]

Sherry wrote:

I'm looking for a tracking form that I can use to determine who I have
specific records on. All the ones I've found show what records I have
for a person or family, but I'd like to go the other way also.

I'd try coming up with something in Access myself, but before I took
the time to re-invent the wheel, I was wondering if someone already had
come up with something like this.

For example, I've printed off a bunch of WWI Draft Registration forms.
I'd like to track which ones I've printed off and ideally, have tables
linked so that I can look at an individual in the database to see what
I have on that individual Does ths make sense?

I've only dabbled with Access in the past.

Last night I sorted through my piles on the floor in order to get ready
to start a new database in my genealogy program. I decided that it's
probably better to start over from scratch than to try to clean up the
mess I have now. While I was sorting, I thought it would be nice to
know just what I have while I'm doing the data entry because I'm always
popping into Ancestry or other web sites and finding stuff... a quick
look would tell me if I've already got it or not! I think once I get
all my people re-entered. Fortunately, it's not a huge database, only
about 1500 individuals right now.

I suppose we all can say "I wish I knew then what I know now" <rbg

Thanks,
Sherry

Actually, I'm lazy, and use a visual chart, made in Excel.

Across the top, the key items (DOB, DOM, DOD, anything else)
Down the side - all the names

In the grid - a full blob (symbol) for "all done" (ie do no more)
A part blob for "I know about it, but haven't resolved it"
An empty blob for "nothing known"

You can vary this endlessly.

Then, visually, I can see if I have all I want about someone. I don't
need to be able to count or categorise, just identify. Basic visual
stuff These days (being wise after the event - the dreadful mess I
made of my first research effort) it's the first thing I set up.

Paul