In a message to ALL, RALPH BEEMER said:
RB>     I'am using 4.5 for windows and I wish to do a small pilot
RB> project but fail to see how to tie it togehter. What I wish to do is
RB> have a table set up with the field names Part#, Decription, Min Qty,
RB> Max Qty which I've done and all is good here. Now the fun, I wish to
RB> have a "form" were I do a weekly stock check and add the part # to
RB> this form and the # off parts and from this it references back to
RB> the Min Qty and if the # of is less then the Min Qty then it takes
RB> the Part#, Description, and orders it on a report "form".
Sounds do-able to me.  You have 1 table as you describe and then a
second table that you fill in each week with the part number and the
quantity in stock.  You then run a query linking the two using the part
number as the common field, returning only those entries where the
actual stock is less than the minimum, calculating for those the value
(Max stock - Actual Stock).  The result table will have the stock
number and the quantity to be ordered.  You can use a report to
generate purchase orders.
Rich
--- 
---------------