Hi,
I have a form with numeric values from 1-5. I would like to have an average of those values inserted into a column in the database. And obviously for it to be updated if the record is updated.
I have been looking at this issue on this forum but all calculated fields seem to refer to ones that aren't stored in the database. I would also need this average value to be shown in other tables later so I suppose it's best to have it in the database.
What would be the best way to achieve this? I'm too confused with triggers, delegate classes etc. to know even where to be looking for the answer.
Thanks!