We have a issue over a consignment note within Access.
> What I would like is for the database to do this:
>
> We have a Sales order form & table. Within this form we have an item
> called Qty_Order.
>
> In a second form we have a consignment form which requires the user to
> enter a despatched figure - Qty_Cons.
>
> What I require (I think!) is the following:
>
> 1. User to go into the consignment form.
> Make Qty_Ordered = Qty_Ordered
> Make Qty_Cons to default to 0
> Have a field which is Qty_Rem
> Make Qty_Rem = Qty_ordered
>
> 2. User enters a figure into Qty_Cons
> Make Qty_rem = Qty_Rem - Qty_Cons
> Write Qty_Rem to table
> Exit table
>
> 3. Re-enter form
> User enters a new consigned figure
> Qty_Ord = Qty_Ord
> Make Qty_Cons = Qty_Rem from table (this then assumes that the
> despatched figure will be the remaining figure)
> Enter a new Qty_Cons figure EXCEPT where Qty_Rem = Qty_Ord then say
> something like (Figure is over qty Order) and force user to next item
> Make Qty_rem = Qty_rem - Qty_cons
> Write Qty_Rem to table
> Repeat until Qty_Rem = 0

If someone could help I would be really grateful as this is becoming somewhat of a bugbear now. Thanks