From: BT3 on
Back when I was just seriously old, I helped design some of the database
layout for MAS/90. POS? You can have it.

BT3

"SergeK" <inventory(a)farlep.net> wrote in message
news:1108659621.307119.310830(a)l41g2000cwc.googlegroups.com...
> dave wrote:
> > Hi
> > I m thinking to build application point of sale system using VB.
> > I have never done before so I'm very much new and couldnt understand
> where
> > should i start from.
> > Can anyone guide me?
> > Can any one suggest how to print to epson tm88iii printer using vb
> > code...becoz we are going to use that printer...
> > Thanx in advance
> > dave
>
> First fo all you should create a database with Products table. You can
> use MS Access. Add to the table next fields:
> ProductKey,ProductCode,Description,Price. Create in the VB the Form for
> edit Product records using ADO connection. Then create Invoice(or
> Sales Receipt) table and IvoiceDetail table. The Invoice table has next
> fields InvoiceNumber,Date,Customer, PaymentTerms, SubTotal,Tax,Shipping
> and Total. The Invoice Detail has fields
> InvoiceNumber,ProductKey,Quantity,Price,Extension. Now you can create
> form for edit Invoice and Invoice Detail using text boxes for Invoice
> and datagrid for edit Invoice Detail records.If you'll be able to do
> these forms you can create your first POS in certain time.
>
> Serge
> www.executivpro.com Golden and Silver Inventory systems.
>