Run into a slight problem which is probably easy to fix but it escapes me. Below is my htlm form......

<form action=FMPro method=post>

<input type=hidden name=-DB value='test_login_'>

<input type=hidden name=-Lay value='admin2'>

<input type=hidden name="-format" value="editwelcome.htm">

<input type=hidden name="-Token" value="[FMP-CurrentRecID]">

<input type=hidden name="-error" value="new_error.htm">

<input type=hidden name="-op" value="eq">

<input type=text name='email_name' size=30>

<input type=hidden name="-op" value="eq">

<input type=text name='ran_pass' size=30>

<input type=submit name="-find" value="Sign In">

<input type=reset value="Reset" name="reset">

</form>

As you can see I want to be able to search on "email_name" as well as on "ran_pass".

My problem is I need the user to search on both fields instead of just one. My db has many "email_name" that are the same but ran_pass is always unique...So as an example i need him to be able to input [email protected] into email_name and if he does not fill in ran_pass he will come up with nothing instead of the first record that has [email protected].

Hope I am being clear!

Thanks

Stu

Hmm... Well, your syntax/punctuation bothers me a little... I prefer something like...

<INPUT TYPE="hidden" NAME="-db" VALUE="test_login_.fp5">

Assuming your code works for you, though, I think what you need is an EXACT SEARCH (==). Most often, people need this for their login/password systems, but I think this will work for you, too. If you still have trouble, it could be due to the @ symbol being a RESERVED character in FMP. I think I had trouble searching for [email protected] data.

I hope this helps. If you need more info on EXACT SEARCH, there's more in the posts and an article at FileMaker Pro, Inc.