Formula to get Record field in related database
I have a field in my Email Messages database that creates a relative formula for each record. I use that formula to pull the email into the Send Email function of my Student Records database. The formula to create what I need is as follows:
"GetNthRecord ( Email Messages::Message ; " & Get ( RecordNumber )
My problem is the GetNthRecord/Get ( RecordNumber ) function. If I don't have ALL the records up in the found set, the record number is incorrect and will pull the wrong email message.
Is there a function that will Get the Current Record (the one open on the screen) or get the record that corresponds to a pre-set unique serial number or the unique Record ID?
Thanks in advance for any help you can give.