Multipart key, matching on blank value
Operating system version
Win 7 Professional
Description of the issue
I have a relationship betweeen two tables that is a three part key. MagCode, Issues, Special Requirements. All records have a MagCode and Issues, but only some have Special Requirements. For those not having a Specil Requirment the field is blank. When trying to display values from the joined tables, the only records that get pupulated are those with a Sprecial Requirement. It seems that FileMaker does not match blank or empty values between the two tables as matching. Is there a way to make the blank or empty values a match?
Steps to reproduce the problem
Created a relationship between Products and MagOptions with the three part key, MagCode, Issues, Special Requirements.
Expected that fields having no value would also match between the two tables, and pull related information.
Only records with all three key values having an actual value pull related information. When Special Requirements is blank in both tables, those records do not pull realted information.