Is this possible?

[vennardk]

I would like to know if it is possible to design something in access 97 to automatically update a table everytime someone purcheses product/s off my internet based store. I am using OScommerce New Zealand.


I have put all the available products in an Excel sheet that I can simply import later. I have also designed another sheet in excel for Shipping prices based on Sub Total of Sales that will be imported later as well.

Where do I go from here?

Thanks!

 

[KeithG]

Access does not support triggers. Are they using a Web Page to enter orders? You could build it into the Web Page.

 

[vennardk]

They are placing orders on a web site. Where can I learn how to write it into the website?

I assume just search google for OScommerce forums?