Hi I am new to Access and learning as I go.
I want to create a database for vegetation monitoring data. At the moment I have the following tables:
Sites (a list of the monitoring sites)
This table has a site ID field only
Species (the species and density recorded at each site over multiple dates).
This table has site ID, species, density and date fields. Because I am monitoring the same sites over multiple dates this is in a long list format (i.e. the site ID and data are repeated for each species and date entry)
Environment (environmental conditions recorded at each site over multiple dates)
This table has site ID, date, dust and condition fields. Similar to the Species table, the site ID is repeated for every date of monitoring.
I don't know how to make relationships between them. I thought that the Site ID would be the primary key - that is possible for the Sites table but not the Species of Environment table because the Site ID is duplicated in those tables (for each monitoring date).
Thanks in advance!
Do I have my data set up incorrectly or is there another way to join the 3 tables?
The purpose of putting the data in Access is so i can create reports that filter and combine the data from the 3 tables. For example, I want to be able to make a report that shows the species data and environment data for one site on one particular date.