Very strange Count problem.... Please help!

[Garu]

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

[comment]

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.

[Garu]

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?

[comment]

Select Contacts here:

[Garu]

You're the man! Thank you so much.