hi,

  i doing with a table for an query ...in My table field called Name of the Equipment & Make..

  now what i want is when select one name then the particular make should come..

 for example..

 Name of the Equipment Make

 Personal Computer HP
 Personal Computer Compaq
 Personal Computer IBM
 Personal Computer HCL
 Personal Computer Mercury
 Laser Printer Wipro
 Laser Printer Epson
 Laser Printer Samsung
 Scanner Toshiba
 UPS Electronic & Controls
 UPS Unitrons

 Like that and what i want is when i select or type Equipment name in an text box or in an query parameter or anywhere .. then the make should extracted for me..

 pls do that need full..
 this blusting my head..


Learn as you can..
------------------------
pap...

From your example it looks the the following should fit the bill:

SELECT Make FROM [Name of the Equipment & Make]
WHERE [Name of the Equipment] = [Equipment Name?];

With this, typing in "Personal Computer" should return the list HP, Compaq, IBM, HCL, Mercury.

Is this all you are trying to do?

-Phil-

Hi,
   I got this, weather it is possible for me to make this in the front end i.e. by using sn text box or list box


Learn as you can..
------------------------
pap...