AnsweredAssumed Answered

Attaching multiple documents of different types (e.g. .xls, .pdf, .doc) to a single record?

Question asked by MatthewPiscitelli on Jun 13, 2011
Latest reply on Jun 14, 2011 by MatthewPiscitelli

Title

Attaching multiple documents of different types (e.g. .xls, .pdf, .doc) to a single record?

Post

I wish to create a relational database.  I have a series of records that list information relevant to archaeological proveniences.  For example, the site, year excavated, unit, and level.  For each provenience, there are a series of analyses that were performed (e.g. botanical analysis, lithic analysis, pollen analysis).  For each analysis there are one or more documents of different types/formats. 

Therefore, I would like to create a record that has the provenience information and then has individual fields for each type of analysis (botanical, lithics) that links to the other documents.  In order words, if I clicked on "Botanics" an Excel spreadsheet, PDF, Word document would pop up.

Any help would be greatly appreciated!  Thanks.

Outcomes