I've done formula queries before (still new, but can successfully make them work). I am banging my head against the wall trying to make something work. The actual goal is simpler than what I post below, but if I can get below to work, then I can achieve my ultimate goal.
This for me works:
Size(GetRecord(1))
Simply, get the count of record ID 1 in current table. The value of '1' is returned.
This does not work
Size(GetRecord(1,"dbid")
I assumed this would look in the table with the dbid id that matched for record ID 1, and return '1'. But it does not. I double checked that Record ID 1 exists and double checked the dbid ID. So i am assuming it is my syntax?
UPDATE: Disregard, as soon as i posted this I realized I was trying to query a table in a different app which doesn't work at this time.
What do I have wrong in this very basic formula?
------------------------------
Mike Tamoush
------------------------------
