I have no idea on how to create a rule to validate this situation,
I have a table named Lot, it contains
type ‘0: foreman; 1: supervisor’
I fill the foremans and supervisor field on Lot by using autocomplete that got values from Person table.
It used to be foremans can only by filled by one name, so the validation is easy by using exist. However, now, the rquirement has changed. It can only be filled by at most two people.
I can using autocomplete for many value and set the limit to 2. But how could I do the validation? Although, I use autocomplete to fill foremans and supervisor, I am still wanting to validate that the person is exist in Person table. How could we validate lists?
Thank you in advance.