Jace Posted February 13, 2002 Share Posted February 13, 2002 Of all the years, I have come across a FIND PROBLEM that is working my common sense into overtime. A landlord has requested a FIND for his Renters by addresses. SIMPLE enough.... Now, here are four addresses he has on file, in a pop-up menu so no spelling mistakes. 404 west market apt 1 404 west market apt 2 404 west market apt 3 404 west market apt 4 QUESTION / PROBLEM is this. When there are multiple entries for each apartment, a simple search should isolate them from the other. HOWEVER...when you do a search/find for 404 west market apt 4, it will bring up all the files, which in this case is apt 1, 2, 3, and 4. When a search/find for all the other address, it picks them out as simple as 1-2-3 and group them like the Find Command was design to do. No mistakes, no errors. At first I thought it was something about the spelling or whatever any other common sense reason might be, but after testing this out on different FMPro 5.5 programs, it always came up with the same results. I have run this string of address on two other computers and tested them... Same results...even when I created a mock data base to test it out on. WHOA.... anyone out there want to try this simple search and see if they have the same problem...... (Please use the same string of addresses) and if so, I need a SOLUTION or a Padded Room... Thanks Jace Link to comment Share on other sites More sharing options...
Anatoli Posted February 13, 2002 Share Posted February 13, 2002 RE: HOWEVER...when you do a search/find for 404 west market apt 4, it will bring up all the files, which in this case is apt 1, 2, 3, and 4. Easy, do search with exact search like: ==404 west market apt 4 and it will find only 404 west market apt 4 I go only sometimes into this topic, but you can find me in WEB topic always Link to comment Share on other sites More sharing options...
Jace Posted February 13, 2002 Author Share Posted February 13, 2002 Thanks Anatoli Kohout I tried the single = sign and it did not work. I went back and tried the double = sign and BINGO, it works great. Question though that comes to mind. Why do many of the address work without even an equal and this requires (2 Equals)? Is this a SNAFU in FMpro??? Thanks Again.... EUROPE HU!!! This is GREAT.... Jason Link to comment Share on other sites More sharing options...
Fitch Posted February 13, 2002 Share Posted February 13, 2002 In a text field, a 4 is the same as a 404 when you search. So it's as though you were searching for all the 404 apts., the final 4 is redundant. Another way to force the correct find is to enclose it in quotes, e.g. "apt 4" would work. Link to comment Share on other sites More sharing options...
Anatoli Posted February 13, 2002 Share Posted February 13, 2002 Precisely as Fitch wrote. Vaughan wouldn't like this, but I gave Fitch ***** rating Link to comment Share on other sites More sharing options...
Vaughan Posted February 13, 2002 Share Posted February 13, 2002 I hope you didn't think I was serious about fitch's blatant, shameless, brazen, attention seeking... ooops, there I go again. I'd better have a little lie down. It's 10:30 am here in Sydney. Don't forget Valentines Day! (It's too late for me!) Link to comment Share on other sites More sharing options...
RussBaker Posted February 14, 2002 Share Posted February 14, 2002 ... and if you want to have a button which will find all records for the appartment currently showing, then assuming the Field "Appartment_Name" contains the 404 west etc create a global text field "g_Appt to Search For" Then the scrip is: # Find all exact match records for this appartment SetField(g_Appt to Search For, "=="&Appartment_Name) Enter Find Mode SetField(Appartment_Name, g_Appt to Search For) Perform Find Make sure the Enter Find Mode and Perform Find steps do not have any of the boxes checked. Russ Baker Canberra, Australia count.zip Link to comment Share on other sites More sharing options...
Fitch Posted February 15, 2002 Share Posted February 15, 2002 "...blatant, shameless, brazen, attention seeking..." I've been called worse. Like I said, who cares about ratings? Do we even need ratings? I think a karma system, more like ebay's, would be better. So I've given up on ratings... Now I follow the Path of Least Resistance. You should too! Join us! You will be assimilated... POLR Power! Link to comment Share on other sites More sharing options...
Anatoli Posted February 15, 2002 Share Posted February 15, 2002 "...blatant, shameless, brazen, attention seeking..." is this about Madonna? Link to comment Share on other sites More sharing options...
Jace Posted February 16, 2002 Author Share Posted February 16, 2002 Thanks everyone.... I really appreciated your help and yes, it did help.... Problem resolved. 5 *'s to each of you.... Jason aaa.zip Link to comment Share on other sites More sharing options...
Anatoli Posted February 16, 2002 Share Posted February 16, 2002 Thank you on behalf of our Global Village FileMaker Community. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8104 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