lookup wizard and custom where clause

Dale,
Here is correct expression if customer_id is a text field:

If customer_id is a numeric field don't use single quotes in your expression.
Backquotes are used for the identification of the field or table.

Thankyou Jane.
I am beginning to have nightmares about comma's, quotes, periods etc.
Thanks for your response.

I will try it out asap.

I must be doing something not right still.
I cut and pasted you example into the field.
"customer_id='".@$_SESSION[$strTableName."_masterkey"]."'"
The customer_id field is a numeric so I took out the single quotes.
Test it. Cant retrieve data.
Put the single quotes back in.

test it. Lookup wizard Test displays. No data in the test lookup box, but no error.

( Im thinking the test may not know what value the @$_SESSION[$strTableName."_masterkey"] at test time)
Build it, and when I open the list, it displays, but the NAMES are not just the customer #.

But, select and I get PHP error Undefined variable: strTableName
Back to the lookup wizard and remove the where and everything works fine.

But the complete array of Customer names are in the html body. I dont want customers to see other customers names. The customers are competitors.
I know this has been talked about before in other posts, there doesnt seem to be a performance issue, although with a large 100000 customer database, its got to be a hit.
But anyway, Im just trying to limit the picklist to the one item. If you make the id field read only, you cannot get the Name value to display, you only get the associated number id.
I have cleared the where clause and disabled the field on the edit form so at least users cant view the picklist. I hope there is a trick to get that where clause working. Would give me the flexibility I need.

PHPRunner is great. I can produce a very nice professional website with the program.
Just to clear up my venting, My real complaint is I cant set a field to read only on the edit page that uses a lookup and have it display the same way as it would in a list. In the edit view it would only display the link field value and not the Display value.
Sorry for the venting.

Maybe something to add to the wish list. To set a field to readonly but use the lookup wizard for how you want the field data displayed.

Im thinking the test may not know what value the @$_SESSION[$strTableName."_masterkey"] at test time

I suspect you're right, how can it display the record you want when the masterkey equals nothing, but it would be handy to have a field from a record id

Issue solved.
When you set the field to readonly, PHPRunner will only display the link field data and not the Display field data on a Edit page.
I left the field as read only, then modified the ...edit.php to do a lookup for the Display field to display the customer name instead of the customer number. And now no array list of all my customers in the ...Edit page html.
It would be nice IF PHPRunner would still use the lookup wizard settings, even though you flag the field as read only on the field.
Great product and great forum.

Would like to see a list of example syntax snippets. The . , " ' are a killer. Actual sample snippets of how to format the custom expressions we are allowed to use.
Thankyou all for your time and suggestions.