Auto-enter Calculation From Previous Portal Record
I'm new to FileMaker Pro 12 and I am wondering if anyone could assist me with the following functionality:
I have an events table with title and details, then I have a portal for all the different dates and locations for the event.
What I am trying to do is for each new portal record created the 'location' field in the new portal record is auto-entered with data from the most recent portal records 'location' field. So that if there's multiple dates for the same location it doesn't have to be entered (a common scenario.)
Any help would be highly appreciated!