access database stock flow, help!

[Anon]

I am in real trouble and have to finish this database by friday can someone help me?

I ave a Product table linked to order details which is linked to orders and then to customers - those are the main tables.

Basically I want to have an order form, fill it in, with the total cost adding up, and then when its done the products would be removed from the stock. I am really stuck!

Any help would be very very much appreciated!!

Chris

[Anon]

All really am asking about is the code to put into the macro if anyone knows?

[gyoung]

Don't want much do you?

Check out the Northwind example database which comes with Access.

Then perhaps ask some specific questions?