Newbies MrTemp Posted August 7, 2007 Newbies Share Posted August 7, 2007 (edited) working in Filemaker 8.0v2 I'm looking get a found set which consists of all records that have matching content in 2 fields within that record, i.e. [color:gray] Include in found set where (content of field_A) = (content of field_ This is for a manual find, no need to script it. This seemed to me to be something Filemaker would have a obvious function for (or symbol to use in a find), but searching through help and doing trial-and-error with various symbols didn't yield any solutions : . Am I just missing the obvious, or is this trickier than it sounds? Edited August 7, 2007 by Guest Link to comment Share on other sites More sharing options...
AudioFreak Posted August 7, 2007 Share Posted August 7, 2007 (edited) In find mode put the criteria into both fields. You can search as many fields as you want in find mode. I do this alot to dwindle down the found set I am looking at. You may also find this interesting. Michael Edited August 7, 2007 by Guest Link to comment Share on other sites More sharing options...
comment Posted August 7, 2007 Share Posted August 7, 2007 Filemaker does not perform calculations during search. You need to add a calculation field (result is Number) = FieldA = FieldB Then search for 1 or 0 in this field. Link to comment Share on other sites More sharing options...
Newbies MrTemp Posted August 7, 2007 Author Newbies Share Posted August 7, 2007 Hmm, I suppose I mis-phrased the problem, though the link was interesting . some background: I'm working in a flat database in which several thousand records hold redundant information between fields (not between records). I cannot kill off these redundant fields, as they contain unique information as well (good data-entry practices have been non-existent for the majority of this database's life-span). My current goal is to find these cases of redundant information, and edit it out of each record. To re-phrase the problem: I'm attempting this find without criteria. I'm not looking for records with two fields containing "Joe" so much as I'm looking for records with two fields containing anything in them, so long as that anything is the same for both fields. I hope that clarifies my problem, and thank you for your reponse. -MrTemp Link to comment Share on other sites More sharing options...
AudioFreak Posted August 7, 2007 Share Posted August 7, 2007 I think Comments suggestion should work for you. Make another calculated field If ( Field A = Field B ; 1 ; "") Then search the new field for 1. That will show you all the records that those 2 fields match. Michael Link to comment Share on other sites More sharing options...
Newbies MrTemp Posted August 7, 2007 Author Newbies Share Posted August 7, 2007 that should do it. thank you both. -MrTemp Link to comment Share on other sites More sharing options...
Vaughan Posted August 7, 2007 Share Posted August 7, 2007 "working in Filemaker 8.0v2" Arrrgh, that is the worst, buggiest version. Run the 8.0v3 patch on it real quick before you screw up all the indexes. Link to comment Share on other sites More sharing options...
AudioFreak Posted August 8, 2007 Share Posted August 8, 2007 "working in Filemaker 8.0v2" Arrrgh, that is the worst, buggiest version. Run the 8.0v3 patch on it real quick before you screw up all the indexes. What was so buggy about it, out of curiosity? Michael Link to comment Share on other sites More sharing options...
Vaughan Posted August 8, 2007 Share Posted August 8, 2007 It screwed up all the indexes. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6234 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