Brian Dunning's FileMaker Custom Functions

MatchExist ( SourceTable.Field ; DestTable.Field ; ReturnField )

Returns a list of matching (ReturnFields)

  Average rating: 3.0 (1 vote) Log in to vote

Dick Impens   Dick Impens - Show more from this author

Share on Facebook Share on Twitter

  Sample input:
MatchExist("Table1.Phone";"Tabl2.Phone"; "ID" )
  Sample output:

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

A handy function to check matching fields from one table to another table, returning the result fields of the destination table. Very useful for checking if a particular value exists in a destination table without having to set a filemaker relationship.

I use it to match import tables against existing tables based on unique criteria in order to decide if an record should be created or updated.

This function uses the SQL syntax to define the table.field. The function will split the table and field for Filemaker SQL to create the correct query. All the values should be given as text "table.field"



Log in to post comments.


Note: these functions are not guaranteed or supported by Please contact the individual developer with any questions or problems.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 16 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: