This topic is locked
[SOLVED]

 Lookup Wizard Where Clause

9/21/2010 10:00:49 PM
PHPRunner General questions
S
Stucco author

I would like to restrict a lookup wizard set of values based on an id that I have within the table being displayed.
" shipment_id = " . $data["id"]
But it says $data is not a recognized variable. I have tried $olddata, $dataold, $values, $evalues, and lots of others with no luck. I just need to access the id field value from the currently edited record. id is not actually available as a field on the form I am editing because it is an autoincrement field.
Thank you!!

A
ann 9/22/2010

Stucco,
there is no $data array here.

You can create custom session variable, say $_SESSION["CustomId"], fill it in the Before display event.

Here is just a sample:

$_SESSION["CustomId"]=$_REQUEST["editid1"];