Hi. I'm making a customer purchase form with textboxes, a cursor, and a table.
The textboxes are txtInvoice and txtName.
The cursor is csrPurchases with fields "ITEM" and "PRICE".
The table tblTransactions has fields "INVOICE", "NAME", "ITEM", and "PRICE".
Is it possible to get values from these textboxes and cursor, and insert or append them into the table?
An example would be a customer buying supplies. txtInvoice is 11111, txtName is "BOB". Customer's purchases will be recorded into csrPurchases, like the following:
PENCIL, 1.00
BALLPEN, 2.00
ERASER, 5.00
How can I insert all data from textboxes and cursor into tblTransactions? I'm hoping to have the following records in the table:
11111, BOB, PENCIL, 1.00
11111, BOB, BALLPEN, 2.00
11111, BOB, ERASER, 5.00
Thank you for your time.
The textboxes are txtInvoice and txtName.
The cursor is csrPurchases with fields "ITEM" and "PRICE".
The table tblTransactions has fields "INVOICE", "NAME", "ITEM", and "PRICE".
Is it possible to get values from these textboxes and cursor, and insert or append them into the table?
An example would be a customer buying supplies. txtInvoice is 11111, txtName is "BOB". Customer's purchases will be recorded into csrPurchases, like the following:
PENCIL, 1.00
BALLPEN, 2.00
ERASER, 5.00
How can I insert all data from textboxes and cursor into tblTransactions? I'm hoping to have the following records in the table:
11111, BOB, PENCIL, 1.00
11111, BOB, BALLPEN, 2.00
11111, BOB, ERASER, 5.00
Thank you for your time.