Extract Data from separate Table
Hi, Within my application, I'm looking importing data from a table into a form for calculation. Was trying to use the GetFieldValues(GetRecord ) command to get a specific value from a table. Will...
Forum Discussion
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))
------------------------------
Brian Cafferelli
Product Marketing Manager | Quickbase
------------------------------