I have 20 date fields, 20 result fields and 10 activity fields.
There are 2 tables Course and Enrollment
Activity field reside in Course table and Date and result fields in Enrollment.
I course has many enrollments. Also there is a field 'Number of activities' (multiple choice text with option 1 to 10) in Course table. Each course can have up to 10 activities. When a course is selected in enrollment table , the activity fields should appear in according to the number of activities listed for that course. For example:
Course 1 has 3 activities, then in Enrollment table when course 1 is selected, Activity 1, activity 2 and activity 3 fields should be displayed. I have created 10 dynamic rules as follows:
When 'number of activities' >=1 show activity 1
When 'number of activities'>=2 show activity 2.
Problem faced: When number of activities = 10 it displays only activity 1 and activity 10. Is there anything wrong with field type or rules?