set field to value from a portal?
I have an Income table and a Membership table that are joined on a unique member ID.
In the Income table, each year a member pays dues, the expiration date for the membership advances to April 201x.
I have a portal to the Income table's expiration date for each member in my Membership table, and I have the portal sorted to show the latest expiration date first.
To make it easy to sort my Membership table in Table View, I want to have a field in Membership that shows the latest expiration date.
How can I assign the latest expiration date from the portal to Income to a field in Membership? Thanks for your help.
PS: I'm using FMPro 10 Mac.