B
Brook
hello,
I have a frminvoices, with two subforms ((1)frminvoicedetails subform &
(2)frminvoicepayments subform)
Subform (1): I use to enter new orders for my invoice, it contains an
invoicesubtotal calculated field and a shippingtotal calculated field
frminvoices: field to copy to the invoicesubtotal, and shippingcost from the
subform (1), then another calculated field invoicetotal.
What I need to do is after the invoicetotal is calculated, populate the
invoicetotal field in my subform(2) for payment acceptance.
Once this is established, I have the subform(2) set up to accept payments
: pmtdate, pmt#, pmtamt, and balance due fields.
I would like for the first payment to be deducted from the invoicetotal,
then then next payment would be deducted from the Balance due.
Any ideas ? Suggestions?
Thanks in advance..
Brook
I have a frminvoices, with two subforms ((1)frminvoicedetails subform &
(2)frminvoicepayments subform)
Subform (1): I use to enter new orders for my invoice, it contains an
invoicesubtotal calculated field and a shippingtotal calculated field
frminvoices: field to copy to the invoicesubtotal, and shippingcost from the
subform (1), then another calculated field invoicetotal.
What I need to do is after the invoicetotal is calculated, populate the
invoicetotal field in my subform(2) for payment acceptance.
Once this is established, I have the subform(2) set up to accept payments
: pmtdate, pmt#, pmtamt, and balance due fields.
I would like for the first payment to be deducted from the invoicetotal,
then then next payment would be deducted from the Balance due.
Any ideas ? Suggestions?
Thanks in advance..
Brook