Lookup multiselect - counting the number of selections
In my application I have a form for recording the published books/papers written by my colleagues. The form has also a lookup multiselect field for selecting the name of the authors from another form that contains the names of all my colleagues. For each published work there is allocated a number of points. For example, 5 points. If the published work has only one author he will get the 5 points. If there are two authors each will get 2.5 points, etc. I have to calculate for each author the number of points he awarded. For that I need to know the number of authors contained into the lookup multiselect field for each record. Any suggestion?
All the best,
Doru