Hello everyone here. I am new to vb.net database programming yet i want to create a point of sale software using it. So far I have created a local database, POSSdatabase.sdf , and I have 2 tables, Inventory and Transactions.
My problem is how do I relate these 2 tables? I have primary key Item Code in both tables. I want to make Inventory table as main maybe, and transaction will reference any data from it.
Another problem is how do I calculate value Quantity and Price column in Transaction to a new column Total in the same table.
Thanks for any help.