c# - database table design for ordered bill interface -

i've order bill data i've enter in database (ms sql) , print bill. requirement c# windows form application. data format of bill is:

particulars  quantity  rate  amount 

the user fills these contents in textboxes row row. how design table keep record?

suppose user fills form as:

receipt : 114 ---------------------------------------------- particulars     quantity    rate    amount particulars_1       2       5       10 particulars_2       1       10      10 particulars_3       4       7       28 particulars_4       10      10      100 ----------------------------------------------                     totol amount    148 

every bill has unique receipt number. number of particulars in every bill different. how design database table keep such kind of records?

later on i've retrieve data of particular receipt number , present in form. please suggest. thanks!

unless i'm missing fundamental, typical , basic databases 101 type scenario.

assuming there need additional information on per receipt basis (date, time, etc) it's simple 1 many receipt table containing receipt id, etc. particulars table containing individual rows.

you appear have errors in data example (10 x 10 != 10).