I need a voice of experience. I am working on a project for school. My project is a small B&M store. I am coding in VB .net I have an Access database with 3 tables - Inventory, SoldInventory and Sales. I need to create a simple POS.
I would like an experienced programmer to tell me if what I envision can be done or if I should look at something different. I have never seen any coding for a POS so I am not sure how they function.
On my form I have a datagrid, a few textboxes and 2 button. When I enter the Inventory Number in the first textbox - hit the first button. The system retrieves the appropriate record from the dataset and enters it into the datagrid. I then enter another Inventory Number and hit submit - a second record is now added to the datagrid. If I dont want an item in the datagrid - I click on that record and hit the first button - that record is now removed from the datagrid. Bascially the first button functionality is Update the datagrid.
I also have 2 more textboxes that take the price of each item and calculate tax and total sales. This information is pulled from the Price field in the datagrid.
The last button has several functions. It will print a receipt created in crystal. It will delete the chosen records from the Inventory table in Access. It will take the tax and total sales and add it to the Sales Table. It will take the information in the datagrid and add it to the SoldInventory Table. And it will clear the datagrid and dataset.
I have not figured out how to code the datagrid - I have tried several things including using the data wizard.
So the question is - Can I add one record at a time into the datagrid or am I reaching beyond Net's ability. Obviously I am reaching beyond mine :) I have googled and can not find anything.
Any advice would be greatly appreciated.