Hello,

FileMaker n00b here. I searched Google Groups for an answer to this,
but couldn't find one.

I'm developing an event management database. It has an Attendee table,
a Registration table and an Event table.

When an Attendee purchases a Registration for an Event, the
relationships and portals are set up so that you can look at an
Attendee and see his Event history. Likewise, looking at an Event, you
can see all that Event's Attendees. (The Registration table is the "go
between" in this many-to-many relationship.)

What I need to do is determine, in a calculation, the city where an
Attendee most recently attended an Event.

I can easily get the most recent event *date* with
Max(Event::EventDate)... but how do I then "get at" the city where that
most recent Event took place?

I won't be at all surprised if I'm making this harder than it is.

Thanks!
-Rob

In article <1164489640.958274.157950 (AT) 14g2000cws (DOT) googlegroups.com>,
robdsteward (AT) gmail (DOT) com wrote:

One way (there may be others):

Do a Find for the events which that person attended, sort the found set
by date, go to the most recent (either first or last, depending on the
Sort order), and get the city.

--
For email, change <fake> to <earthlink>
Bill Collins

Bill wrote:
Please correct me if I'm wrong, but that cannot be done in a
calculation, can it?

Thanks,
-Rob

In your relationship between Event and Registration, sort by date,
Descending. And unsorted between Registration and Event. If you put a
portal of Events on Attendee, the topmost record should be the most
recently attended event.

A simple calculation Attendee::LastCity = Event::City should pull the
first related record, ie the most recent Event.

G



robdsteward (AT) gmail (DOT) com wrote:

In article <1164494416.813282.284620 (AT) f16g2000cwb (DOT) googlegroups.com>,
robdsteward (AT) gmail (DOT) com wrote:

You are right. It can be done in a script.

--
For email, change <fake> to <earthlink>
Bill Collins

robdsteward (AT) gmail (DOT) com wrote:

Provided only one event can occur on any given day, create a
relationship from the EventDate in Attendees (your calc field above) to
the Date in Events. You can then show the EventCity related to the date
shown.

If you want more than one Event per date:
-Create an auto-entered serial number field in Events ("EventNumber")
and populate it.
-Create a lookup field in Registration to grab the EventNumber when
adding an Attendee.
-Create a relationship from Attendees to Registration based on the
AttendeeName (or number, if you're using one, which you should).
-Create a calc field ("MaxEventNumber") in Attendees =
Max(Registration::EventNumber)
-Create a relationship from the "MaxEventNumber" field to the
"EventNumber" field in Events.

You may then pull the most recent EventCity into Attendees.