Forum Discussion

AmyChristensen1's avatar
AmyChristensen1
Qrew Trainee
3 years ago

Field value changes, record ID is constant - how to look up current field value?

I know I have to be making this too hard. I need to have a field pull the current numeric value in field 31 from record #1 of an unrelated table. There is no need for any other kind of relationship h...
Gary1's avatar
Gary1
Qrew Assistant Captain
3 years ago

If you want to avoid a relationships, just use this formula query. 

ToText(GetFieldValues(GetRecord(1, [_DBID_YOUR_TABLE]), 31))

Replace the DBID with the real DBID of the table with the field you want. (You can get the DBID from the bottom of the Advanced Settings of the table. I don't know why they hide it so well.)

You can also replace ToText with ToNumber or whatever data type you need. Without any conversion the formula returns a textlist.



------------------------------
gary
------------------------------