Newbies provage Posted March 31, 2004 Newbies Share Posted March 31, 2004 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 Link to comment Share on other sites More sharing options...
Ocean West Posted March 31, 2004 Share Posted March 31, 2004 create a calc FieldC isEmpty(fieldA) FieldD isEmpty(FieldB) FieldC = FieldD FileMaker Version: Dev 7 Platform: Mac OS X Panther Link to comment Share on other sites More sharing options...
Newbies provage Posted March 31, 2004 Author Newbies Share Posted March 31, 2004 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... Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7345 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now