Outstanding Orders

[KenshiroUK]

Okay I'm little confused about how I am going to go about this. When an Order is created based on whats in stock. So if quantity of stock is 10 and I order 11, within my form it will automatically be placed as Quantity - 10, Quantity To Follow will be 1.

My boss wishes for some sort of automatic outstanding process. So when a product is back in stock and the quantity is inputted into my products table it automatically prints out the outstanding order based on oldest order first. I have no idea how to even attempt this or begin.

 

[jdraw]

Ken,

It may just be me, but it seems you are creating several threads all of which relate to the same issue/development project. It may be helpful to the reader to know more about your project ( at least identify the posts as somewhat related).

I find it confusing to answer a post, and then see a new thread along the same theme. It isn't clear if you are not happy with the advice, the suggestions weren't useful or whether or not you have even seen/read them.

http://www.access-programmers.co.uk/forums/showthread.php?t=252612
http://www.access-programmers.co.uk/forums/showthread.php?t=252913
http://www.access-programmers.co.uk/forums/showthread.php?t=252435

 

[KenshiroUK]

Hi jdraw, I do apologise for the amount of posts I have created when relating to this project I am working on. A while ago I was asked to create a fully functioning orders database for my manager. I am a novie as you probably have guessed with the amount of related posts when it comes to access. Although I am trying to learn as I go along. I am very happy with the advice I have been given.

Sorry if this has caused any problems.

 

[jdraw]

It really hasn't caused me an issue, but anyone trying to follow your project will not be aware of these separate posts. Also, people responding to posts that perhaps seem to just stop and not "Solved" /completed without a link to next post in the project may just ignore the post.

Good luck with your project.