MatchExist ( SourceTable.Field ; DestTable.Field ; ReturnField )
Returns a list of matching (ReturnFields)
Average rating: 3.0 (1 vote) Log in to vote
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"
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.