Expression Builder?

S

Saxman

I have created a very simple form which has two fields associated with
stock control.

One field contains the stock level for a sole item (A). The other field
contains total amount ordered (B).

If I type in the stock level in (A), say 500, how can I get that to reduce
to 498 by typing and entering 2 in field (B)?
 
S

Saxman

I have created a very simple form which has two fields associated with
stock control.

One field contains the stock level for a sole item (A). The other field
contains total amount ordered (B).

If I type in the stock level in (A), say 500, how can I get that to reduce
to 498 by typing and entering 2 in field (B)?
Click to expand...

I'm sure I need to delete field (A) and create a new table which records
the total stock level? I will then need to create a form and view the
stock level from there?
 
Top