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.
Thank you, this is precisely what I was looking for. I was getting tons of solutions for how to do a query when I just needed to go straight to a record. I just needed the right syntax. Much appreciated!
