I have a simple database with to 2 tables:
I created a one-to-many relationship between these 2 tables.
Now I would like to create a field in the parent table called:
In this field I would like to store "automatically" how many Participants (children) where created for the specific Event (parent).
So if a participant is added for an event, this count would be count+1.
If a participant is deleted, there should be 1 subtracted from the count.
And this without any manual user interaction offcourse... ;-)
Any help is more then kindly appreciated !!!