If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
My Access query
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 |
Thread Tools | |
Display Modes | |
|
|