aturner51
Posts: 6
|
| Posted: 12/17/2004, 10:24 AM |
|
I have created a Receipting database that has both a ReceiptDetails, FeeTypes and Receipts table. I have added custom code to be able to submitted information to the receiptdetails table. However, it's inputting the quantity and the feetypeid (which is the type of fees), and not the feecost or feetotal. So, I'm not sure if my custom code (shown below) is missing a step. I am using CCS with ASP and a SQL backend.
Function ReceiptDetails_FeeTotal_BeforeShow() 'ReceiptDetails_FeeTotal_BeforeShow @199-C45204F9
'Custom Code @200-73254650
' -------------------------
ReceiptDetails.FeeTotal.value = ReceiptDetails.FeeCost.value * ReceiptDetails.FeeQuantity.value
ReceiptDetails.Total.value = ReceiptDetails.Total.value + ReceiptDetails.FeeTotal.value
if ReceiptDetails.FeeTotal.value = 0 then
ReceiptDetails.FeeTotal.value = "<font color=white>" & ReceiptDetails.FeeTotal.value & "</font>"
end if
' -------------------------
'End Custom Code
End Function 'Close ReceiptDetails_FeeTotal_BeforeShow @199-54C34B28
|
 |
 |
peterr
Posts: 5971
|
| Posted: 12/17/2004, 4:20 PM |
|
I'm not sure if all your field values are accessible in the events of the "FeeTotal" field, so please try moving your code to the "Before Show" event of the form, rather than the field.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
peterr
Posts: 5971
|
| Posted: 12/17/2004, 4:21 PM |
|
BTW, what type of field/control is FeeTotal?
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
|
