Help me Please

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have been trying for days to accomplish one thing.....
I have a problem with finding a way to update a field in a table with the
information gathered in a query.

Supplies Table- has a field for [units in stock] and [units on order].

SupplyOrdersTable- has a check box for completed Supply Order.

PurchaseOrder form has a subform that takes in the information for
supplyorderdetail corresponding to its table. relavent field is [quantity]

Query based on SupplyOrders with details included on products ordered with
quantity field displayed.

Query based on above query with the query based on a yes in completed check
box.

Everything is working up to this point. Problem i am having is trying to
figure out how to get the original table of supplies to take the number
entered in for quantity.

I want this field to update along with units on order with the queries based
on the completed or not completed supply orders.

I sorta understand access. but I am having a great deal of dificulty trying
to work this out in my head. I need to be walked through this....thanks in
advance

Arleta
 
Arleta

It is most likely not a good idea to have [units in stock] and [units on
order] fields. This is data which is derived from your stock
transactions data (which includes orders), and as such should not really
be stored in a table. Generally, the recommendation would be to just
record the goods ordered and the goods received into a table. Then you
can easily determine the current units in stock and units on order for
each product, whenever you need it, by way of a simple Totals Query.
 
Back
Top