My Access query

[Access form problem]

I am trying to create a Sales application for my self use.

Description: My work is picking orders from customers.
Problem : Now an order may contain single item OR multiple items. Each item
is having further parameters like (Type, Specifications, Unit Price, and
Warranty). So is there any way to manage at run time like if i fill No of
ITEMS =5 then 5 times only i have to fill the details . Also what fields I
need to add in the TABLES.

For each Item , I need to fill 5 details . Type , Specification , Unit Price
,Qty & Warranty

Ex : An order may be for –

2 No Desktop @ Unit Price 40000/- each Warranty 2 Yr , Spces : Dual Core , 2
GB , 500 GB etc. Make HCL
1 Printer @Unit Price2000/- Warranty 1 Year , Specs : DMP 21 Col , 80 Pin ,
Make TVSE
& 1 UPS @Unit price 1800/0 Warranty 3 Year , Specs : 800 VA , 2 hr backup .
Make Neumeric

 

[June7]

Why do you have to indicate number of different entries? Use a form that
allows you to go to New Record and enter data. Keep going to New Record
until you have entered all you need to. The real question is how do you
want to initiate the GoTo New Record action. With the built-in record
navigator bar or with a custom button or just by tab or cursor movement
to next row?

For fields you name some and probably need to include CustomerID,
CustomerOrderNum, InvoiceNum. This structure depends on what other
tables may be in your design and how they relate.