I have an excel app that generates dates for 120 items. Then the app opens up MSProject and feeds these dates to a template and creates an individual file containing a baseline gnatt chart.
I now want to use VFP to generate and store these dates and create a MSproject chart as needed instead of storing static MSProject files. Since dates change each of the 120 items have four dates: baseline start, baseline finish, actual start, actual finish. These 120 items are grouped into departments responsible.
How do I set up this database to be the most effecient and easy for updates? Thanks for the help.