auto decrement

[ann]

i am creating a database on an inventory of parts. in the first table i have the part details -like part id, description, location, quantity, critical level.
in the second table, i have the usage of the part, as in , the record of the items withdrawn from the store and the fields are - date taken,name of person, part id, amount taken out.
i need to know how to decrease the quantity of the part in the first table whenever a part is withdrawn and recorded in the second table.
please help?
also, is there a way to record the date & time automatically whenever a part is withdrawn?
thank you

 

[ann]

Thanks Luiz, but I cant gain access into that webpage :
Do i have to register

 

[Luiz Cláudio]

Hi,

read this text about inventory control:
http://www.utteraccess.com/forums/download.php?Number=304826

Luiz Cláudio C. V. Rocha
São Paulo - Brazil

i am creating a database on an inventory of parts. in the first table i

have the part details -like part id, description, location, quantity,
critical level.

in the second table, i have the usage of the part, as in , the record of

the items withdrawn from the store and the fields are - date taken,name of
person, part id, amount taken out.

i need to know how to decrease the quantity of the part in the first table

whenever a part is withdrawn and recorded in the second table.

 

[ann]

thank you luiz, i was able to download, am going to read it up now, and hopefully things will get better
----- Luiz Cláudio wrote: -----

Hi,

read this text about inventory control:
http://www.utteraccess.com/forums/download.php?Number=304826

Luiz Cláudio C. V. Rocha
São Paulo - Brazil

i am creating a database on an inventory of parts. in the first table i

have the part details -like part id, description, location, quantity,
critical level.

in the second table, i have the usage of the part, as in , the record of

the items withdrawn from the store and the fields are - date taken,name of
person, part id, amount taken out.

i need to know how to decrease the quantity of the part in the first table

whenever a part is withdrawn and recorded in the second table.