stock check in database
any ideas will help thank you.....:WAVE:
[349 byte] By [nk_86] at [2007-11-11 11:59:16] 
Hi, for my project I am going to adding databases which wil have all the clients and employee details, also I am adding stock check this will be a database showing amount of stock left, but I do not know how will I able to do this I have no clue but look forward to adding the stock check function..
any ideas will help thank you.....:WAVE:
# 1 Re: stock check in database
1. What kind of database are you using?2. What kind of front end are you using?
3. What have you got so far?
Hack at 2007-11-11 23:42:32 >
# 2 Re: stock check in database
I am going to use MYSQL, I am just planning the project have not yet started and ideas wil do also, thank younk_86 at 2007-11-11 23:43:33 >
# 3 Re: stock check in database
you need to make a table for the stock .. it will contains informations about what the stock has and one of fields will be the count .. once the client request something the count will decrement by one and when the employee add new item to the stock this count should increment ...and if you want to generate reports for your project you should log this all in a new table client-orders say ...
Amahdy at 2007-11-11 23:44:36 >
# 4 Re: stock check in database
I am going to use MYSQL, I am just planning the project have not yet started and ideas wil do also, thank youWhere are you in the design stage?Do you have a table design?
Have you settled on what you will be using for a front end? (I would suggest VB.NET with ADO.NET to do your connection and database calls.)
Hack at 2007-11-11 23:45:42 >
