Look Up In Edit MOde

Jim,
I recommend to use Search or Advanced search to look up.

However I'm not sure I understand you fully.

Please clarify.

Jim,

[quote]
Sergey,
Sorry I didn't make myself clear. I have a 26,000 + name address file, that I want people to add their email address to, they would come to an input screen that would allow them to input their last name, the system would lookup all possibilities and allow them to select the correct name and input their email address to the record containing that name. It has to be as foolproof as possible because they are all retirees and as a group are not very computer literate.
I tried creating a second table and using the lookup wizard, I can't seem to find a way to make it work correctlly.
Can I do this with PHPRunner, I know that I'm probably going to have to hardcode the lookup parameters.
The product really works well and I really appreciate your help.
Jim F

Jim,
just build the pages for your table with PHPRunner and disable everything you don't need.
Disable Add, Delete, View and other pages. Leave List and Edit only.

Make LastName the only searchable field and Email - the only editable.
Users will open the List page, type in their Last name in Seacrh box, then press Edit for the correct record and type in a email address.
After you build the pages you can modify them to make the captions more informative for your task.

Jim,

[quote]
As usual, I tried to make it harder than it really is.
Can I modify the following to allow for prompt of specific entry from the Before List Load:
function ListOnLoad($strSQL)

{

//** Check if specific record exists ****

global $conn;

$strSQLExists = "select * from mailist2 where name "Starts with 'Prompted value (Enter Last Name)'"

$rsExists = db_query($strSQLExists,$conn);

$data=db_fetch_array($rsExists);

if($data)

{

// if record exists list all possibilities

else

{

// if doesn't exist reprompt "Enter Last Name Again"

}
}
Thanks
Jim Freeman

Jim,
Your suggestions about function ListOnLoad($strSQL) are unrealizable.
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.