March 31, 200421 yr Newbies Is it possible to set up a relationship that will match two empty fields as being equivalent? (Seems simple enough but I have tried calculation results equal to "" as well as global text empty fields, and many other ways, but nothing seems to work...) Version: 7
March 31, 200421 yr create a calc FieldC isEmpty(fieldA) FieldD isEmpty(FieldB) FieldC = FieldD FileMaker Version: Dev 7 Platform: Mac OS X Panther
March 31, 200421 yr Author Newbies I have also came up with this solution - I just thought it was weird that we needed to "trick" FMP into matching empty fields by matching results of a secondary calculation... Thanks for your help and confirmation...
Create an account or sign in to comment