Need something like a trigger or procedure in access

[shripaldalal]

Hi,

I enter some data in access via ASP which records some goods that are
purchased.....only their quantities.....not rate of purchase or
anything else. Those goods go for manufacturing at rate 0. Later on
when I get an invoice for those goods I enter their price / rate / etc.
Can access automatically make changes in the manufacturing entries
also, so if price for x is 100 then even the manufacturing records show
raw material rate as 100 ? Some kind of relation or something can be
set up between records ? If access does not permit then do I HAVE TO
USE SQL SERVER, which gives me triggers/stored procedures to do these
kind of things ?

Regards,
Shripal D.

[ManningFan]

Either use a query to make the conversion, or run a SProc against the
table to update it on the fly.

shripaldalal wrote:

Hi,

I enter some data in access via ASP which records some goods that are
purchased.....only their quantities.....not rate of purchase or
anything else. Those goods go for manufacturing at rate 0. Later on
when I get an invoice for those goods I enter their price / rate / etc.
Can access automatically make changes in the manufacturing entries
also, so if price for x is 100 then even the manufacturing records show
raw material rate as 100 ? Some kind of relation or something can be
set up between records ? If access does not permit then do I HAVE TO
USE SQL SERVER, which gives me triggers/stored procedures to do these
kind of things ?

Regards,
Shripal D.