I have a design situation where fields and values as mentioned below,
Batch Type --> Course type --> Class Type --> Class
A --> B --> C --> D
A --> B --> C --> E
A --> B --> C --> F
A --> B --> C --> G
A --> B --> C --> H
A --> B --> C --> I
A --> B --> C --> J
K --> L --> M --> N
K --> L --> M --> O
K --> L --> M --> P
K --> L --> M --> Q
K --> L --> M --> R
K --> L --> M --> S
K --> L --> M --> T
I want a Contact to be assigned a Batch Type, Course Type & Class Type. Based on that would like to know what all Class value are possible for that.
Also, there must at least be a case a created for each class with status as "New". There may be additional new cases created for each of the Class.
I am planning to use a Product object to have the Batch Type, Course type, Class Type, and Class fields. This would ensure to list out all the class that a contact must complete even without the case records. Is this a good choice?
Also, I want to report for each contact how many class has been assigned, how many are not started/new, in-progress and completed.
I am planning to create a report using the contact and product object. Any additional constructive suggestions please?
Also, its possible that an employee may be assigned to different Batch Type, Course Type & Class Type. Based on that new cases must be created for the corresponding classes.
I would like to retain the status of case classes for earlier batch type. What would be the best way to achieve it?
