[Rockhounds] Numbering Specimens (WAS: Paint)

[Jim Daly]

Kreigh,
You bring up an interesting point.In my system, there's a catalog entry number, and a specimen number. A specimen with more than one species on it has multiple catalog entries (the unique field required by Access), all with the same specimen number. Each is assigned sequentially. There's also a field for "associates", so that if I have a specimen with, let's ay, pyrite, galena and sphalerite, there are 3 entry lines. The pyrite line shows galena and sphalerite as the associates, etc. That way they are cross-referenced.
Jim Daly

--- On Tue, 12/2/08, Kreigh Tomaszewski <Kreigh at tomaszewski.net> wrote:

From: Kreigh Tomaszewski <Kreigh at tomaszewski.net>
Subject: Re: [Rockhounds] Numbering Specimens (WAS: Paint)
To: "Rockhounds at drizzle.com: A mailing list for rock and gem collectors" <rockhounds at lists.drizzle.com>
Date: Tuesday, December 2, 2008, 4:07 PM

John,

If you had started numbering specimens when you started collecting they would
roughly be in a time sequence. But the number is just a unique identifier to tie
together the specimen, the label, and the catalog entry. If you have ten
specimens of the same rock from the same trip you have ten numbers (some of them
may turn out to have micro crystals of something unique). And it really
doesn't matter what order you put them in.




      

--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---