We are using Alpha5V6 to develop regular windows Application. We face with a problem and wish to have your help cracking it.
I created a sample sample screen to explain our problem. Please see the attached Screenshot. (Screenshot.jpg)
The screen is created over a table called "document". (columns docid, docDt, doctypeCd, DocTypeDesc, DocFee, tax)
There is a Lookup field rule on Document.DocTypeCd. The lookup has source as table "DocType" (columns doctypecd, doctypedesc, docfee)
The lookup field rule also populates DocTypeDesc and DocTypeFee. Tax is a calculated field in Document table with its expression as 0.06 * DocFee.
When I choose a doc type from the lookup or type it directly, Description and fee get the values automatically as intended. Tax also gets calculated when I tab through the field or save record.
Now We added a button "EFile" (See Screenshotafter.jpg). The "OnPush" Event Runs an xbasic script. This script assigns a value to DocTypeCd Programatically. (example: topparent:DocTypeCd.value = "DEED"). Though this is a valid value for Doctypecd in the lookup table, the form does not show me the corresponding doctypedesc and docfee. The tax field also does not get calculated. What else should I do in the code to make it work properly?
A quick working Suggestion is highly appreciated as we are fast approaching our deadline and this is a show stopper.
thanks
Atchut Gollakota
I created a sample sample screen to explain our problem. Please see the attached Screenshot. (Screenshot.jpg)
The screen is created over a table called "document". (columns docid, docDt, doctypeCd, DocTypeDesc, DocFee, tax)
There is a Lookup field rule on Document.DocTypeCd. The lookup has source as table "DocType" (columns doctypecd, doctypedesc, docfee)
The lookup field rule also populates DocTypeDesc and DocTypeFee. Tax is a calculated field in Document table with its expression as 0.06 * DocFee.
When I choose a doc type from the lookup or type it directly, Description and fee get the values automatically as intended. Tax also gets calculated when I tab through the field or save record.
Now We added a button "EFile" (See Screenshotafter.jpg). The "OnPush" Event Runs an xbasic script. This script assigns a value to DocTypeCd Programatically. (example: topparent:DocTypeCd.value = "DEED"). Though this is a valid value for Doctypecd in the lookup table, the form does not show me the corresponding doctypedesc and docfee. The tax field also does not get calculated. What else should I do in the code to make it work properly?
A quick working Suggestion is highly appreciated as we are fast approaching our deadline and this is a show stopper.
thanks
Atchut Gollakota
Comment