Attaching multiple documents of different types (e.g. .xls, .pdf, .doc) to a single record?
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.