Hello,
Thanks for the reply!
The code for is Field_sT_ExitTicker. This is the field in the Access based on whose value I want the fields inside the Expand to change
Field_string
{
Prompt: "Ticker"
Control: (Key '((StkEnTrades project sT_Ticker) rename sT_Ticker to ticker) join StkMain' 'ticker' mandatory:true width: 12.8 fillin: (sT_StockName) from: (stockname) )
}One of the fields inside the Expand whose value is calcualted based on the value of Field_sT_ExitTicker is calculated using the Rule_sT_EnTradeNum
function()
{
rec = false
try rec = QueryFirst(("StkEnTrades where ( sT_Ticker = " $ Display(.sT_ExitTicker) $ " and sT_Type = " $ Display(.sT_Type) $ " ) sort sT_EntryDate"))
if Record?(rec)
return rec.sT_TradeNum
else
return false
}Is the reason for the field not notifying the Access’s Record Control any error in my code? Could the reason be just that it is a calculated field?
Thanks in advance,
ajith