Hi All,

I have adopted "Event Management" starter from FMP11 and I came across with this very strange problem which I spent so much time trying to figure it out but no success.

I have created this relationship "Contacts::k_ID_Contact ad Events_Guests::kf_ID_Contact" with the objective of counting the number of events attended by a contact.

I have created EventsAttendedCount in the Contacts table and assigned a calculation "Count(Events_EventsGuests::kf_ID_Contact)" but to my surprise it's not do the calculation.

Please look at the attached file and tell me what's wrong with my calculation.

Thanks.

EM.zip

Your calculation field is set to evaluate from the wrong context (compared to the layout it's placed on).

---

IMHO, you have way too many table occurrences.

Your calculation field is set to evaluate from the wrong context (compared to the layout it's placed on).

---

IMHO, you have way too many table occurrences.

Thanks for your reply... what needs to be done to get it working on it's current layout?

Select Contacts here:

You're the man! Thank you so much.