[Rockhounds] Numbering Specimens (WAS: Paint)

[DonH]

Jim Daly wrote:

> Kreigh,
> Yes, it was forced by the software- as far as I know, any table in any relational database has to have a unique field. Just pure serendipity that I could use it that way.
> Jim
> 

Hi Jim,

I'm not sure how you set it up, but it need not be that way.  The 
specimen number is the only thing that needs to be unique.  The other 
tables are linked by using the specimen number as a unique key.  When 
they are joined, the data is presented as part of the same application.

Best,
Don