calculation problem

[piet123]

see this thread...
http://www.access-programmers.co.uk/forums/showthread.php?t=69237

hi everyone,

can we please start this thread again...

- since may'04 (when we started this thread), i have tried many of the suggestions in the replies to this thread, and as i am no expert in access i repeatedly ended up at the beginning.

- if look at the history of this thread, you will notice that i need just a very small and simple db.

- since may'04 i did alot of reading and 'self-study' on access, and i'm sort of "getting the picture" now, but could find nothing to sort out my problem.

- most of you guys seem to know alot! about programming in access, and i have great respect for you... but if anyone could please suggest something SIMPLE! to sort this problem i'm having. (or is this wishfull thinking on my part?)

have a good day !
Regards,
Piet.

 

[Brianwarnock]

Hi Piet
First a disclaimer
All the guys on the other thread gave good advice, they were trying to stop you starting down the wrong path and finding yourself in a big hole. They are more experienced than I on DB design and I would not argue with them, but I think I can solve your current problem, just don't come back later and say that scouser gave me c**p advice

Ok 1st off isn't the Current Stock is the available stock and therefore that is what you need to update, why carry another field with available stock?
On this premise I attach a revised DB, hope it helps.

Brian

 

[Rich]

http://members.iinet.net.au/~allenbrowne/AppInventory.html