Storing the bill into tables

[mailavi]

Sir!

i have a query is as follows

i want to store the bill generated by the shopkeeper .....

the Bill Consists as follows...

Master Table
(itemcode(PK), itemdesc, unitprice)


BillNO: Date:
s.no itemcode itemdesc unitprice quantity total

these are the thing in the receit so i want to store this thing to the tables

pleas help me in creating the table with key fields.........


i am confused in creating tables..please helpme

[Saii]

you already have a master table with Pk.
next you need a transaction table with columns (itemcode,quant ity) and itemcode will be a FK in this table.

you don't need to store the total as it can be calcaluted using (unit price * quantity(unless you have a different calculation)).

Do you also have to store tax component?


Hope that helps!!!