Hola ,

  I got a DB data as below,

Equipment Name

Personal COmputer

Printer

Scanner

Other Accessories

  * each having different type like different company & different model.

   and all the data are compiled as to be 500 records..
it ill be like
  Personal Computer - 200 Records
  Printer - 100 Records
  Scanner - 100 Records
  Others - 100 Records

  All the data is in one table called tblmain..


 Now my boss told me to get the data in Datatable view and in form view through front end..

  Like
        From1 (Combo Box - Equipments Name)
        From2 (Combo Box1 - Make ; Combo Box2 - Model)

 What i need is what i select the Equipment Name in CB1 and pass over to From2 then the CB1 & CB2 should show the particular make & model of the Equipment . Real task is the data field will contian all the make & model . Like filtering the data as Autofiltering ..

 If u not able to understand plzz reply me



bye
------------------------
pap...

I don't understand what you want to do.


mmcdonal

I ill give an Example.. it may be too long.

Table1:
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..
------------------------
pap...