Need help in a point of sales software

[phrankus]

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.

[JamieHowarth0]

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