Extract Data from separate Table

Hi Pat, yes there is a way you can use a dynamic record identifier instead. Consider this example:

This formula will always get all records on the current table where the value in Field 50 is 2, and within those records, get a list of the data in Field 9: 

GetFieldValues(GetRecords("{'50'.EX.'2'}"), 9)

---

And this formula will dynamically get all records on the current table where the value in Field 50 is equal to the value in the current record's "Part Number" field, and within those records, get a list of the data in Field 9: 

ToText(GetFieldValues(GetRecords("{'3'.EX.'" & [Part Number] & "'}"), 9))