hello,
i need some assistance in making the right decisions here. i have been requested to create a system that will do the following:-

when a customer gives his order, it is not written on a paper, everything is on soft copy. the data clerks enter user name and password(1st form) to access the form(2nd form) where she will enter all the customer requires.

when she is through with entering the details...the form is sent to the manager for approval which when approved is sent to the stores manager to issue the materials required by the customer.

there is an element of networking because all of this is done right there and then while the customer is awaiting his goods.

any ideas will be highly appreciated...other requirements is reordering level of the inventory, viewing of the report and query that shows items that were not issued by the store manager because they were not available in the inventory.

Pliz HELP...

Email:lex.quoba@gmail.com