Hi Jeff:
Thank you for answering my questions and your willingness to help.
Since 7 is my field ID, I would move it to the end of the formula, correct?
GetFieldValues(GetRecord(XX,[_DBID_STUDENT_DEMOGRAPHICS]),7)
When a student enters his/her ID on the Application table, I want the formula to look at all records in the Student Demographics table.
I will keep working on this.
Thank you,
Roula
Right, you are almost there.
The part you now have as 'XX' needs to be the Record ID of the record you want to get the field values from. If the Student ID is the related Student in the Student Demographics table, that would work and return the values from field ID 7 from that specific record in that table.
Thank you, Jeff.
