I'm struggling with this a bit. The Project Managers like to be able to input into a form that would look similar to this.
Project # Nov 14 Dec 14 Jan 15 Feb 15 Mar 15 100101 $60000 $50000 $40000 100102 $20000 $20000 $10000 100103 $16000 $18000 $20000 100104 $15000 $18000 $20000
I'm struggling with the data model. I currently have it set up like this but I don't know if its correct.
PK Project ID
Project Code
Project Title
Client
Original Budget
Start Date
Duration
PK Budget
Budget Month
Budget Year
Amount
I'm just not sure how else to do this.
Has anyone ever had to do this? These two tables are linked.