[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Find Exact records

Posted on 2011-09-12
3
Medium Priority
?
456 Views
Last Modified: 2012-05-12
I have a database  (see attached) it has a script that allows a user to find records. I want users to look records based on the field'FirstField'. The problem I run to is that if a user types 'joe' it brings any records that have the word 'joe' in it. I just want to bring the exact record entered by user. I know I can use '==' and that will bring the exact match. But I do not want users to type '=='. Is there a way for me to add this to the script so that the user may only enter what they are looking for?
Find-Exact.fp7
0
Comment
Question by:PachecoPrimo
  • 3
3 Comments
 
LVL 6

Expert Comment

by:ThomDroz
ID: 36526752
Peach
One working example attached
0
 
LVL 6

Expert Comment

by:ThomDroz
ID: 36526756
PachecoPrimo

Sorry, here it is
0
 
LVL 6

Accepted Solution

by:
ThomDroz earned 2000 total points
ID: 36526765
PachecoPrimo

Not sure why it dosent want to upload... Find-Exact.fp7
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
Conversion Steps for merging and consolidating separate Filemaker files The following is a step-by-step guide for the process of consolidating two or more FileMaker files (version 7 and later) into a single file with multiple tables. Sometimes th…
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

590 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question