Need help in a point of sales software

I have desinged a point of sales software but i need a lot of help to upgrade it as it is not standard and i'm a young programmer. I have designed the following forms (Cash Sales, Credit Sales, stock and Items). When a user inserts a record for cash or credit sales) I want that particular product entered to be deducted from the stock.. Kindly help me.

re: Need help in a point of sales software

Hi phrankus,

Firstly welcome to Bytes. If you haven't already done so, please read and become familiar with the Forum Guidelines.

Are you familiar with SQL and UPDATE statements? If not then I suggest checking out MSDN and Googling/Binging for database connection and data update examples - or even better, look at using a data access layer (DAL) generation tool like SubSonic, NHibernate or ActiveRecord.

In my opinion, if you have designed this from scratch, it sounds like you need to establish a solid architecture for your application from the database layer up - your application will rely heavily on data of one kind or another and you need to design your application's behaviour to reflect that before even thinking about designing front-ends.

Hope this helps.

codegecko