Similar to using the dependent linked lookup wizard drop down boxes, I'd like to limit the selections from a lookup wizard drop down box based on the value of the master key passed to the detail record using the where clause.
I've tried unsuccessfully to use:
"IP_IO_ID=".@$_SESSION[$strTableName."_masterkey"]
(IP_IO_ID is the office id number which is the Master-Detail key)
This WHERE clause for the lookup wizard gives an SQL syntax error.
Can anyone help with the right WHERE clause for this?
Many, many thanks!
Take Care... Mike.
