[soaring_eagle]

Right, i'm doing ict at school and we're making a database for a shop. I've got this form sorted.

What i want to be able to do is to delete this order for the item (but beware i want to keep the stock levels so that they are correct, at the moment they change the levels of stock when you order an item) so that if the customer changes their mind then the stock control thingy will still be accurate and uptodate.

Thanx

[Young Twig]

Never used Access, so, sorry, but I can't help...

[Jay Tea]

I've used Access plenty, but I'm really not sure what you're asking. Is there something not working? Do you need help getting started?

[JerryLove]

If I understand your description...

I would not recommend keeping a "number in stock" table and deleting from it when an order becomes pending... You would do better to create a query-table on a regular interval which had the number available based on "inbound", "arrived, "pending", and "completed" tables. Use a query to the "pending" table to subtract from the "inventory" table.

Alternaely, you can actually move the items from one table to another. When an order is placed, don't just remove it from inventory; move it to a "pending order" table. Then don't delete the order, cancel it, and move it from the "pening order" table back to inventory.

There are several ways to accomplish all this... from a purely business standpoint, the preference is a master record and query tables for the status's... from a project standpoint, you can probibly just create the 4 tables yourself.

[soaring_eagle]

okay so i didn't attach what i wanted to start with, which doesn't make it that clear, sorry. This is what i have at the moment, does it help?