If total stock is set to 0 = unable to make transaction.

[microsoftgirl]

I have a query that works out the amount of stock that needs reordering, based on delivery(what the store purchases from it's suppliers), transaction(what customers purchase from the store) and stock level.

The query is working fine. It tells the user how many stock needs to be reordered and if no stock is needed to be reordered then the reorder amount is set as "0".

However, I want to make it so that if the total stock is set as 0, a transaction cannot be made. Would this be done in the reorder stock query, or a different way? And how would I go about doing this please?

When the stock level is at 0, I was thinking of having a message box appear saying that a transaction cannot be made.

 

[jdraw]

Can you show us your tables and relationships?

Here is a data model that shows how this might be set up.
http://www.databaseanswers.org/data_models/inventory_control_for_retail/index.htm

You will see a reorder level (it stocks drops to this level, then issue a reorder transaction) and a reorderAmount (the quantity to be reordered, when stock level falls to or below reorderLevel).

 

[jdraw]

Duplicate post because of long wait time-- text removed.

 

[microsoftgirl]

You will see a reorder level (it stocks drops to this level, then issue a reorder transaction) and a reorderAmount (the quantity to be reordered, when stock level falls to or below reorderLevel).

Thank you, it shows what the reorder amount is, I'm just wondering how you would issue the reorder transaction automatically.

 

[microsoftgirl]

Can you show us your tables and relationships?

Here is a data model that shows how this might be set up.
http://www.databaseanswers.org/data_models/inventory_control_for_retail/index.htm

You will see a reorder level (it stocks drops to this level, then issue a reorder transaction) and a reorderAmount (the quantity to be reordered, when stock level falls to or below reorderLevel).

Also these are my relationships, I think this is what you mean anyway. I had to post separately because I was only on my 9th post.