Good Afternoon,
I am a project manager in construction and I'm currently looking to make my life easier on projects by tracking the progress and issues associated with high rise apartment builds.
I have created a database that does just that and has been working fine until I wanted to add a snag (defective works) tracker within this. I have created a separate table for snag monitoring but I can't get it to associate correctly with other tables.
The tables in the database are as follows:
Activities - which contains the fields "Activity ID" (key) and "Activity Duration"
Apartments - which contains just "Apartment ID" (key)
Apartment Details - which contains "Apartment ID", Activity ID", followed by several other fields containing apartment data for monitoring "Programme Start Date", Programme Completion", "Actual Start Date", "Actual Completion Date", etc.
Snags - which contains "Snag ID No.", "Description", "Date raised" and "Date Closed"
Each individual apartment can have a number of activities, each individual apartment can also have a number of snags.
The 3 tables Activities, Apartments and Apartment Details are linked by many to one relationships with the joining table being Apartment Details.
The issue is I don't know how to join the Snags table into the equation.
I've tried a many to one relationship with the Snags table and all three Activities, Apartments and Apartment Details tables with no joy. Apologies if a similar topic is covered elsewhere or this is relatively simple but I have not that long ago started using Access 2010.
Thanks in advance for any help.
I am a project manager in construction and I'm currently looking to make my life easier on projects by tracking the progress and issues associated with high rise apartment builds.
I have created a database that does just that and has been working fine until I wanted to add a snag (defective works) tracker within this. I have created a separate table for snag monitoring but I can't get it to associate correctly with other tables.
The tables in the database are as follows:
Activities - which contains the fields "Activity ID" (key) and "Activity Duration"
Apartments - which contains just "Apartment ID" (key)
Apartment Details - which contains "Apartment ID", Activity ID", followed by several other fields containing apartment data for monitoring "Programme Start Date", Programme Completion", "Actual Start Date", "Actual Completion Date", etc.
Snags - which contains "Snag ID No.", "Description", "Date raised" and "Date Closed"
Each individual apartment can have a number of activities, each individual apartment can also have a number of snags.
The 3 tables Activities, Apartments and Apartment Details are linked by many to one relationships with the joining table being Apartment Details.
The issue is I don't know how to join the Snags table into the equation.
I've tried a many to one relationship with the Snags table and all three Activities, Apartments and Apartment Details tables with no joy. Apologies if a similar topic is covered elsewhere or this is relatively simple but I have not that long ago started using Access 2010.
Thanks in advance for any help.