Hi,
I am new to access, and building a fairly large researchdatabase. So far I have one 'master' table and five related tables that each linkto it. I can get single table queries to run, and multi-table queries betweenthe master table and one other related table, but that is it. I need to createqueries using data from two or more of the other tables, but every time I dothe results is blank. I have tried many videos and online tips but everyexample seems too unrelated to be helpful to me. For information:
I am working with archaeological data
The 'Master' table is a list of archaeological sites,their location, overall details about the site and the kinds of things foundthere.
Tables 2-6 are each a category of data (e.g. burials,structures, metalwork) - these tables each have relationship connections to themaster table
Tables 2-6 are not mutually exclusive - each site may havedata of all types, or some, or just one.
Many categories in Tables 2-6 are exactly the same, toensure Access knows to connect them (e.g. site ID, individual ID, site name,depositional context) but some are not, out of necessity, because the data ineach is different.
Each site has an ID number that is consistent acrosstables 2-6, and each entry in tables 2-6 has its own unique ID number.
For example:
Site ID 62 (Tower of London) may have three recordedburials (Table 2, IDs 233-235), and five metalwork finds (Table 4, IDs 41-6).
How do I get queries to work containing multiple tables?For example, if I wanted to know if cremations and other burials were oftenfound in the same contexts (e.g. graves, pits, ditches)?
Would I create a query using the master table - Site ID,Site name and then burials table - Site ID, site name, Individual ID,depositional context and then the cremations table - Site ID, Site name,Individual ID, depositional context?
I have tried adding relationships between tables 2-6 butit would get VERY complicated if each was related to each other, in multiplecategories.
Sorry if I have been too vague, I can provide more data asneeded, but obviously no data specifics as the information is sensitive. Also, this question is cross-posted to the Microsoft website (here - Access - Multi-table queries - Cannot get data to display - Microsoft Community) - apologies for this, I found that before this site, but this seems like a better place to ask the question.
Sorry again for my lack of knowledge, as I said Access is new to me.
Thank you!