Search Before List

How can I input a name(starts with) before the sight does an initial list?

It sounds like you need to take it through to the screen where you create a login. This allows you to make logins for different people or even different groups of people. You can allow different screens and uses to different groups.

HTH

[quote]
I've already tried that, but becomes to complicated for my group. I've got a db with 26,000+ retiree's in it and I have a field with lstname,firstname mi and I tried using the zip code as a password. works okay but they have to enter the lastname,firstname, mi exactly the way it is in the db or they get nowhere.
If I could find a way to do the username based on the name, but use a "starts with match" I would be okay. BTW "the only allow them to edit their own records option" in the login setup, if you have identicals, will allow you to login with either password and allow you to edit both records. My zip code fields are inconsistent, some have +4, but , I could sql those into another field.
The legal people have said that they don't care if I expose all of the partial matches with zip i.e. "smith,bar" gets me five possibles. As long as I don't expose the names and zip of the whole 26,000 + to the whole world.
The usage on this is subject to court scrutiny(major CH11 bankruptcy involved) and these are retirees which the company furnished to the court appointed committee which I work for. The problem is they gave us only names and addresses, to do paper mail communications and we need the email addresses of the ones who have them.
I'm dedicated to not doing anymore customization than is necessary and staying within the phprunner frame work.
What I really need to do is display the search "bar"(I've customized it to do the search with just "name" and "Starts with" before it lists. But I'm having trouble tracing the initial listing mode logic to kill it.
At this point I'm open to all suggestions.
Jim Freeman

Jim,
I recommend you to check off No records on the first page on the Edit SQL query Tab and change your pages by hand. For example, you can delete Show all button from LIST page.

Jim,

How I missed that option I'm not sure. Your advice worked flawlessly. However, I found for my usuage that invoking through search.php gave me a lot more options. Since it is the advanced search, I used three qualfiers last name, first name, and zip code.
Performed as written.
I get more impressed with the product everyday.
Your help is greatly appreciated.
Jim Freeman