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.
