I have an access database (Access 2000 file format) to keep accession records at a small botanical garden. The accession information table, tblAccdata, is linked to tblColdata (Collection information), and tblPlantnam (taxonomic information). I am a newbie—self taught years ago, then forgot everything and am now returning to fix some things up.
I’d like to be able to add links to photos, pdf documents, and maps (maybe just more photos or pdfs) to the accession records. I might also want to link photos to the taxonomic information records. The way that I am thinking of is to create a table, tblLinkedObjects, that has 4 fields, LinkID, Object, Caption, Notes.
Each accession might have any number of objects linked to it (although as a practical limit, I’d say probably not more than 50 at the most). Some accession records might have no objects, some might have 50. A single object might be linked to more than one record.
So here is where I’m not sure. Should I just add 50 fields to the accession information table, and 50 fields to the taxonomic information field, name them LinkedObject1, LinkedObject2, etc.? and then fill with a LinkID however many of those fields as I have objects I want to associate with a record? Am I overlooking a cleaner way to do this?
Any suggestions for better ways to do this would be appreciated.
I’d like to be able to add links to photos, pdf documents, and maps (maybe just more photos or pdfs) to the accession records. I might also want to link photos to the taxonomic information records. The way that I am thinking of is to create a table, tblLinkedObjects, that has 4 fields, LinkID, Object, Caption, Notes.
Each accession might have any number of objects linked to it (although as a practical limit, I’d say probably not more than 50 at the most). Some accession records might have no objects, some might have 50. A single object might be linked to more than one record.
So here is where I’m not sure. Should I just add 50 fields to the accession information table, and 50 fields to the taxonomic information field, name them LinkedObject1, LinkedObject2, etc.? and then fill with a LinkID however many of those fields as I have objects I want to associate with a record? Am I overlooking a cleaner way to do this?
Any suggestions for better ways to do this would be appreciated.