AnsweredAssumed Answered

set field to value from a portal?

Question asked by DonorTracker on Apr 28, 2011
Latest reply on Apr 28, 2011 by LaRetta_1


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.