Form Coading problem

[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

 

[Arvin Meyer [MVP]]

The Northwind sample database that comes with Access has all the features
you want. You will need to make a copy, change some names and add some
fields, but the basic structure is there.