Latest record in a portal

[rookie101]

Hello everyone,

I'm just a 3 days old of Filemaker but I keep reading all the post here.

My question is how to get the latest record in the portal or in a related records?

I made a personal data database, with a master table holding persnoalID,lastname,firstname and middlename and made a related schedule table which holds scheduleID,personalID, gotocdate, and topicfor2day.

Personal data

personalID: 0001

personal data:

lastname: john

firstname: Duel

middlename: Cruz

gotocdate: ?: i want to put the latest gotocdate here, is it possible?

schedule:

scheduleID:1

personalID:0001

gotocdate: 01/01/07

topicfor2day: john 3:3

scheduleID:2

personalID:0001

gotocdate: 01/02/07

topicfor2day: job 3:3

scheduleID:3

personalID:0001

gotocdate: 01/03/07

topicfor2day: math 3:3

I hope it's possible.

Thanks in advance.

[mr_vodka]

See if this helps you get in the right direction.

Link