I have a master detail scenario, where the use enters header information on one page and clicks save which redirects them to the Details Add Page after the record is added. The problem is when the Details add page is opened, no items are in the lookup field. When i test the query to populate my lookup in the database, there are results.
This is the query in Add Page: Before Process:
global $conn, $strTableName;
if ($_SESSION[$strTableName."_masterkey1"])
{
$str = "select CNum, CoType from dbo.vw_Claims where CNum = '".$_SESSION[$strTableName."_masterkey1"]."'";
$rs = db_query($str,$conn);
$data = db_fetch_array($rs);
$_SESSION["CNum"] = $data["CNum"];
}
And, the where clause in my lookup field properties is:
" dbo.vw_Claims.CNum = '".$_SESSION["CNum"]."'"
If i don't redirect to the Add Page, the lookfield works as it should.
Am i missing something?