Add a value entered into a form to a table

Jelani

New member
Local time
Today, 03:27
Joined
Apr 14, 2008
Messages
3
i am creating a database about a business. the problem is when i enter a value in the form for deliveries, for field qty delivered, it does not add this value onto the overall stock level
 
Is that field bound to the table? That's the easiest way to do it.
 
yes the field is bound to a table but how do i add the value entered in the form to the overall stock level
See the link in Uncle Gizmo's response and you don't need to store the overall stock level.
 
See the link in Uncle Gizmo's response and you don't need to store the overall stock level.
but is there a way to do it by storing the overall stock level as there are other functions of the database that are reliant on the stock figure
 
but is there a way to do it by storing the overall stock level as there are other functions of the database that are reliant on the stock figure
Calculate the level when you need it as Allen Browne suggests.
 

Users who are viewing this thread

Back
Top Bottom