AnsweredAssumed Answered

Formula to get Record field in related database

Question asked by on Oct 30, 2014
Latest reply on Oct 30, 2014 by philmodjunk


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.