I ill give an Example.. it may be too long.
Equipment Name Make Model
Computer HP P-4
Computer Compaq P-4
Computer Siemens P-2
Printer Wipro LQ-5400
Printer Epson L1 – 2450
Printer Tvs 2400
Scanner Hp s4200
Scanner Acer sg45
UPS Agni 1KVA
UPS TVS 4KVA
These are the datas which i have (assume) then
Iam going to creat an from called FROM-1 & FROM -2,
and In FROM-1, i want to place One Combo box & One Command Button. The Combo box as the data for name for the Equipments (i.e. ,Computer , Printer , Scanner , UPS ) & When i select any one of the Equipment and move to the FROM-2. In FROM-2 I placed two Combo Boxs (CB1 & CB2) & one Button , CB1 having the data for make & CB2 having the data of Model..
Now what should i want is When i select Computer in the FROM-1 , then the FROM-2 should show only the Make & Model for Computer which i enter allready and when i select the make and model it should give the dataview for the computer only, i know it can be generated by an query...
But for this pls give me an idea
Learn as you can..