Building a project management database, need some table/relationship help
I have not built a database in about 10 years (and I used MS Access) but the need has presented itself. I need to create a database that tracks multiple construction projects and the costs and budgets associated with each. The databse will track what money is available, what has been committed to the project, and what has been spent on the project to date.
I have always had trouble with setting up the tables/relationships and complicating things that don't need to be complicated. So I make a cheatsheet of what I am trying to do and have attached that. I listed at the bottom the tables and fields I am planning to setup.
I am just looking to have someone help me figure the best way to make these tables relate to eachother.
I should be able to setup the form and do all of the calculations (i think).
Any help and/or ideas are very much appreciated.