Hi,

I want to create a field in a table that auto-calculates based on a calculation of many related records

More specifically,

I have a table of Contacts (name, e-mail, etc.) and a Table with a one-to-many relationship called Events that are events relating to these people. e.g., Phone call with Fred on August 6th.

I want to create a field in contacts which can be displayed in list view and will hold the date of the last event relating to the person. i.e., automatically look at all the related events, find the most recent and output the date. I want this to be updated automatically (E.g., a new event gets entered, the field changes) and work for existing contacts as the database already has a good amount of data.

Anyone have any ideas?

I'm a bit of a newbie, so the answer may be simple.

Thanks!!

You can sort your Events relationship in descending order by this date (in your relationship graph) and then just place the events date directly on your layout.

You can also leave your relationship alone (if you don't want to sort it because of many other reasons) and place a one-row portal on your layout and sort the portal descending on this date). You can make the portal transparent. If you are using a table view then you can't use portal trick because portals don't work on table views (it might appear to work but only the first related record will ever display just as if there was no portal).

Got it, thanks!!