Formula Checkbox Help Needed

I see we are all trying to read Stephanie's mind here. Let's try my mind reading. I think she has a record with an email address on it, and she wants to know if that email exists in another table.

This can be done with the formula query.   Example below this would be a formula checkbox field type.  But replace the 99 with the field ID in the other table which holds the email address.  Would replace this table reference here  [_DBID_OF_OTHER_TABLE]  with the table name that you will see in the advanced settings for the other table.  

var text QUERY = 
  "{99.EX.'" & [Email Address] & "'}";

var number NumEmailsInOtherTable=
Size(
GetRecords($QUERY, [_DBID_OF_OTHER_TABLE]));

IF($NumEmailsInOtherTable>0, true)

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------