General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Tracking record attributes over time
I'm a newbie to FoxPro and have been thrown a project that is twisting my brain.
We are creating a database of business activities (print reports, distribute reports, etc.), each activity has a number of attributes (who does it, how often, how long it takes, etc.). Easy stuff so far.
The kicker is we want to track these various attributes over time. e.g. Reports get printed once a week and this takes 1 hour - from 2000 till 2003; from 2003-2005 Reports get printed twice a week and this will take 20 minutes. Of course, all the various attributes can change independently for any time period.
Right now we are looking at creating a new record every time one of the attributes changes.
Something like:
Print Reports -
Frequency: 1/wk
Duration: 1hr
Time: 2000-2003
Print Reports.1 -
Frequency: 2/wk
Duration: 20min
Time:2003-2005
This seems like a really poor solution. There MUST be someway out there, even in some other program, that will allow attributes to change over time like that.
Has anyone had to tackle a similar problem, or know of somewhere I could go to learn how others have solved this problem?
Any help will be greatly appreciated.
- Jasen.
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only