Add a value entered into a form to a table

[Jelani]

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

 

[boblarson]

Is that field bound to the table? That's the easiest way to do it.

 

[Uncle Gizmo]

have a look at this example from Allen Browne






.........

 

[Jelani]

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

 

[Rabbie]

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.

 

[Jelani]

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

 

[Rabbie]

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.