Hi all,
I am trying to create a simple POS (Point of Sale) db. For this purpose I created 3 Tables (TblSales, TblProducts and TblReceive). The tables are linked (one to many) by product ID key. For sales I have a main form which contains 2 filtered combos so I can change the product from category , 1 subform linked to TblSales showing the current sales and 1 command button for adding a sale (add a record in the SalesTbl). Also I have another form for import via listboxes the receiving products (stock) in tblReceive. So far everything works fine. My problem is that I can’t find a safe way so if I sale a product the same product can be removed from Stock table and I have the rest of quantity. Also in the main form I am trying without success to create 3 unbound text boxes which by lookup function from queries finding if the selected product for sale is in stock or not.
The table fields are:
TblProducts: ID, Category, Product
TblSales: SaleID, Date, Sale (quantity), ID (relation to TblProducts ID)
TblReceive: ReceiveID, Date, Receive (quantity), ID (relation to TblProducts ID)
Αny help is appreciated,
Thanks in advance
I am trying to create a simple POS (Point of Sale) db. For this purpose I created 3 Tables (TblSales, TblProducts and TblReceive). The tables are linked (one to many) by product ID key. For sales I have a main form which contains 2 filtered combos so I can change the product from category , 1 subform linked to TblSales showing the current sales and 1 command button for adding a sale (add a record in the SalesTbl). Also I have another form for import via listboxes the receiving products (stock) in tblReceive. So far everything works fine. My problem is that I can’t find a safe way so if I sale a product the same product can be removed from Stock table and I have the rest of quantity. Also in the main form I am trying without success to create 3 unbound text boxes which by lookup function from queries finding if the selected product for sale is in stock or not.
The table fields are:
TblProducts: ID, Category, Product
TblSales: SaleID, Date, Sale (quantity), ID (relation to TblProducts ID)
TblReceive: ReceiveID, Date, Receive (quantity), ID (relation to TblProducts ID)
Αny help is appreciated,
Thanks in advance
