Need help developing a small relational db
June 6, 2007 9:52 AM Subscribe
Help me properly set up a very small relational db. This is a teensy bit over my head, so mainly I want to establish that I'm not going terribly wrong before I get too far into this.
posted by desjardins to computers & internet (5 answers total) 2 users marked this as a favorite
The data is organized as follows:
One location -> many goals
One goal - > many projects
Each project -> many criteria (the criteria are the same across all projects)
Different locations can have the same goals, and I guess this is where I'm getting stuck. I have a LocationID table, and a GoalID table. Do I add fields for multiple goals in the location table? Or do I add fields for multiple locations in the goal table? Also, various locations can have the same type of project, so I have the same dilemma with the ProjectID table.
I have Access 2003. I cannot buy or learn a new DB program right now.