Hello kind folks. I am very new to Access and am putting together a very simple database for tracking bicycle segment race attempts and history of Personal Records (PRs) associated with those segments. I think I lack some fundamental understanding of how to properly structure relationships and/or architecture of this simple database. Although, I've watched many YT videos and online tutorials, progress has stalled, so I ask here for a little push in the right direction.
Here are some of the particulars:
- tblAttemptLog contains all member attempts on any segment recorded as a duration with the associated attempt date.
- tblMembers contains member data. There are many members.
- tblSegments contains segment data. There are many existing segments in the area.
- tblPRs contains the date and duration that a member has a previously recorded PR duration on a segment. Not all member/segment combinations have a history of a PR. This table is populated with historical PR data when the member joins the club and remains static.
Basically just need to query for a display of all the Segments, the members and their AttemptDurations plus any associated PRDuration (if it happens to exist for that member on that segment).
I've attached a screenshot of my current design. Thank you for your consideration and *gentle* feedback.