Checkbox set & radio button problem
In my Table (People), it has a field (Category) which is set to a checkbox set with values (Teacher, Tutor, Prospect, Staff, Admin)
In another layout i have a field (Category) also have the values (Teacher, Tutor, Prospect, Staff, Admin) which is set to a radio button. By choosing the radio button, records from Table (People) are filtred to show in a portal based on People's Category.
My Problem is If a person has 2 or more Category checked, this record does not show on the portal if the corresponding category is chosen. Any idea?