Forum Discussion

KennethMelvin's avatar
KennethMelvin
Qrew Trainee
9 years ago

Trying to produce a Summary Report of Multiple Multiple Choice fields.

I have a database with quite a few records that I've created to track a process end to end, but they different types of record use different parts of the whole process. The database stores the dates o...
MCFNeil's avatar
MCFNeil
Qrew Captain
9 years ago
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.
KennethMelvin's avatar
KennethMelvin
Qrew Trainee
9 years ago
I think I take your overall point regarding parts of the process (and that is probably fair), but I'm not entirely sure I understand what you mean regarding '1 field'.

All of the different Durations (and check fields) are in 1 field each.