Hello,
Basically i am trying to create a stock control system.
I have two tables one with the products and their stock levels which are updated daily and the order table where orders are made according to the products in the products table with their stock level.
i have created a form for the orders and i have used a combo box to get the product names
SELECT [Products].Part, [Products].PartName FROM Products; - this is what i used for the combo box which is a table/query
my question is how can i have a field to be updated with the selected products stock so when ordering the stock can be seen
Thank you
Basically i am trying to create a stock control system.
I have two tables one with the products and their stock levels which are updated daily and the order table where orders are made according to the products in the products table with their stock level.
i have created a form for the orders and i have used a combo box to get the product names
SELECT [Products].Part, [Products].PartName FROM Products; - this is what i used for the combo box which is a table/query
my question is how can i have a field to be updated with the selected products stock so when ordering the stock can be seen
Thank you
Form lookup help
