Hi,
I would very much appreciate any help give.
Im creating database for handling stock of shoes with different sizes and orders.
I have main form - Stock
with a subform - Orders
Each forms have fields with size range (5, 5½, 6, 6½ etc)
In the main form (Stock) shows size range and number of shoes currently in stock in store for each size.
In subform (Orders) shown size range for the pairage ordered for a particular size. There could be multiple incoming orders for one style of shoes.
* When order arrives I need a button to allocate that particular Order to the Stock (add values from each Size field to the same Size field in the main form Stock)
* I also need a button to Save the Order into Order Archive and delete from Current Orders
I thank you in advance for any help given.
Anton
I would very much appreciate any help give.
Im creating database for handling stock of shoes with different sizes and orders.
I have main form - Stock
with a subform - Orders
Each forms have fields with size range (5, 5½, 6, 6½ etc)
In the main form (Stock) shows size range and number of shoes currently in stock in store for each size.
In subform (Orders) shown size range for the pairage ordered for a particular size. There could be multiple incoming orders for one style of shoes.
* When order arrives I need a button to allocate that particular Order to the Stock (add values from each Size field to the same Size field in the main form Stock)
* I also need a button to Save the Order into Order Archive and delete from Current Orders
I thank you in advance for any help given.
Anton