Hi,
I have a table with pk- Index that stores customer details.
I have a second table that stores the items sold, description, barcode number, sale price and discount.
On the main Invoice form, that is linked to qrySalesInvoice, the customer records are displayed/updated by telephone operator.
In a subform that is linked via Index, the sales details are displayed for that invoice.
This works well, but we often need to credit one or more items. Business practice dictates that we cannot amend the original invoice, so we need the credit to be raised as a new record, but as negative values.
Before I split the sales detail into another table, there used to be 10 sales fileds that were stored in the same table, and using code borrowd from the forum, I worked out how to copy the invoice, add "CR" to the invoice number and multiply all values by -1.
But using the subform method I am lost as how to proceed.
I have gained so much from this forum in the past, and for that
Many Many Thanks.
Regards
dazadd
I have a table with pk- Index that stores customer details.
I have a second table that stores the items sold, description, barcode number, sale price and discount.
On the main Invoice form, that is linked to qrySalesInvoice, the customer records are displayed/updated by telephone operator.
In a subform that is linked via Index, the sales details are displayed for that invoice.
This works well, but we often need to credit one or more items. Business practice dictates that we cannot amend the original invoice, so we need the credit to be raised as a new record, but as negative values.
Before I split the sales detail into another table, there used to be 10 sales fileds that were stored in the same table, and using code borrowd from the forum, I worked out how to copy the invoice, add "CR" to the invoice number and multiply all values by -1.
But using the subform method I am lost as how to proceed.
I have gained so much from this forum in the past, and for that
Many Many Thanks.
Regards
dazadd
