Calculate field based on many side field value

Sorry for the horrible analogous DB
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/11447-calculate-field-based-many-side-field.html

two tables
"keg"
"can"

one to many relationship between keg and can. a single keg could fill
many cans

"keg" has fields originial volume and current volume
I would like the current volume to be the amount left in the keg based
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11447
on the amount poured into individual cans.

keg.currentvolume = keg.originalvolume - (total volume of cans from
that keg)

hope this is enough info..
thanks,


*

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

Hi Martino,

Take a look at MVP Allen Browne's sample, and see if you can apply it to
your situation:

Inventory Control: Quantity on Hand
http://allenbrowne.com/AppInventory.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11447


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/ex...tributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

"Martino165" wrote:

> Sorry for the horrible analogous DB
>
> two tables
> "keg"
> "can"
>
> one to many relationship between keg and can. a single keg could fill
> many cans
>
> "keg" has fields originial volume and current volume
> I would like the current volume to be the amount left in the keg based
> on the amount poured into individual cans.
>
> keg.currentvolume = keg.originalvolume - (total volume of cans from
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11447
> that keg)
>
> hope this is enough info..
> thanks,
>
>