Howdy oh misguided one (Misguided Missle),
Welcome to the forum!
If I understand correctly (nice description by the way) you would want to have a field in Table 1 which is set up as a calculation field. The calculation would be:
=Last(Table2 :: Scolarship_Offered)
Under storage, consider whether you want this to be unstored or stored...typically I do not store and let it update in real time...but you know your use best.
Do the same for the last term attended and you're home free...right?
Let us know how it works out...Note that this calculation technique would be subject to the sort order of your portal, it will give you the data on the last portal row, not necessarily the last on the calendar, so be careful.
Thanks a lot.. Your solution worked like a charm..
Am already falling in luv with File Maker..
Is there any documentation or turtorial / resources where i can get more knowledge about these calculations and stuff...
I have gone through Video tutorials of Lynda.com to learn about the basic as well as advanced features of FM. But i want to learn more about the calculations and stuff..
Thanks in advance.