About this Article:
FileMaker Pro 7 has a great new function called FilterValues that compares two return-separated lists and returns the common values. But what if you want the opposite? What if you want to return values that are in just one but not both lists? You can write a formula that compares every value in the lists, but how do you know how many items the lists contain? You can create a conditional calculation and a recursive custom function that handles lists of any length. Here's how.
Technical editor John Mark Osborne is president and owner of Database Pros, offering FileMaker resources on the Internet. He is author of Scriptology, a speaker at FileMaker Developer Conferences and Macworld conferences, and a trainer for the Professional Training series created by FileMaker, Inc. http://www.databasepros.com jmo@filemakerpros.com
Keyword Tags: Database, Database Development, Development, FileMaker, FileMaker FileMaker Pro