AnsweredAssumed Answered

Multipart key, matching on blank value

Question asked by RussHibbing on Sep 18, 2010
Latest reply on Sep 20, 2010 by TSuki

Summary

Multipart key, matching on blank value

Product

FileMaker Pro

Version

11

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 result

Expected that fields having no value would also match between the two tables, and pull related information.

Actual result

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.

Outcomes