Forum Discussion
MCFNeil
9 years agoQrew Captain
It recommend putting all those "parts/stages" into a child table of the parent project. Then all your dates would be in one field, all your durations would be in one field, and all your yes/no answers would be in one field, just multiple records. Then creating the summary reports and durations will be a breeze.
This might take some data export and import, but with some plaining it will be much better in the long run.
And will make your app data structure much cleaner.
This might take some data export and import, but with some plaining it will be much better in the long run.
And will make your app data structure much cleaner.
MCFNeil
9 years agoQrew Captain
If you put them in a child table, your common duration calculation will only need to be made once.
Say you have 5 parts to the process; Plan, check, build, inspect, finish.
And you have a start date & end date for each of those, and in turn a duration.
If you make a child table you would need 4 fields on the child table;
[Part Type], multiple choice field (Plan, check, build, inspect, finish.)
[Start Date]
[End Date]
[Part Duration] = [End Date]-[Start Date]
Now you would have 5 child records for each part of the project, but the great part here is all your "durations" are in one spot, to if you want to make reports, that compare durations from one part to another, you can.
Overall, your reporting capabilities grow greatly because you have all 'like' data in one field.
Say you have 5 parts to the process; Plan, check, build, inspect, finish.
And you have a start date & end date for each of those, and in turn a duration.
If you make a child table you would need 4 fields on the child table;
[Part Type], multiple choice field (Plan, check, build, inspect, finish.)
[Start Date]
[End Date]
[Part Duration] = [End Date]-[Start Date]
Now you would have 5 child records for each part of the project, but the great part here is all your "durations" are in one spot, to if you want to make reports, that compare durations from one part to another, you can.
Overall, your reporting capabilities grow greatly because you have all 'like' data in one field.