Somebody pls help.
Am trying to develop a simple invoicing system using VB6 and access 2000. In access I have 3 tables, (1) Products which has ProductID, ProductDescription Qnty and Unitprice.
(2)Invoiceheader with Invoice details,date, Customername etc. and (3) invoicedetails which requires a table and this is where am having nightmares. In the Invoicedatails, we can have say like 10 items and the best way I thought was to use a DBgrid. Unfortunately, it updates the underlying recordset after a COLEDIT. ie every time I want to move to a new row, the recordset must be updated and making any edits on the grid thereafter DOES not edit the recordset. I have not found any good documentation on Flexgrid but am thinking its rather complex using flexgrid. Any ideas, links suggestions or otherwise is most welcome.
Am trying to develop a simple invoicing system using VB6 and access 2000. In access I have 3 tables, (1) Products which has ProductID, ProductDescription Qnty and Unitprice.
(2)Invoiceheader with Invoice details,date, Customername etc. and (3) invoicedetails which requires a table and this is where am having nightmares. In the Invoicedatails, we can have say like 10 items and the best way I thought was to use a DBgrid. Unfortunately, it updates the underlying recordset after a COLEDIT. ie every time I want to move to a new row, the recordset must be updated and making any edits on the grid thereafter DOES not edit the recordset. I have not found any good documentation on Flexgrid but am thinking its rather complex using flexgrid. Any ideas, links suggestions or otherwise is most welcome.