Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to do Autolookup Query

Status
Not open for further replies.

Machlink

Technical User
Apr 3, 2004
25
CA
I have the following Equipment table which consists of common code. I need to filter data based on Code. Suppose if user select 2310 then he must able to see only 2310 ID's only. I would appreciate if anyone help me on this.

ID Description code
3000 Planned Outage - No Special Protection 2000
3050 Customer Related - No Special Protection 2010
3100 Conductor - No Special Protection 2100
3150 Overload - No Special Protection 2200
3200 Enviromental - No Special Protection 2300
3205 Thunderstorm/Lightning - No Special Protection 2310
3210 Porcelain Arrestor Only 2310
3215 Poly Arrestor Only 2310
3220 Porcelain Arrestor W/ Pole Ground 2310
3225 Poly Arrestor W/ Pole Ground 2310
3230 Static Wire Only 2310
3235 Static Wire W/ Pole Ground 2310
3240 Static Wire W/ Porcelain Arrestor 2310
3245 Static Wire W/ Poly Arrestor 2310
3250 Static Wire W/ Porcelain Arrestor & Pole Ground 2310
3255 Static Wire W/ Poly Arrestor & Pole Ground 2310
3260 Arrestor > 6 Feet From Equipment 2310
3265 Arrestor At Equipment 2310
3270 Tree Problem 2340
3275 Tree Growing Too Close To Line 2340
3280 Tree Overhanging Line 2340
3300 Animal - No Special Protection 2400
3305 Guthrie Guard Only 2400
3310 Insulated Wire Only 2400
3315 Xmer Bushing Cap Only 2400
3320 Guthrie Guard & Xmer Bushing Cap 2400
3325 Guthrie Guard & Insulated Wire 2400
3330 Guthrie Guard & Xmer Bushing Cap & Insulated Wire 2400
3335 Xmer Bushing Cap & Insulated Wire 2400
3350 UG Cable Failure - Cable Age 2140
3351 Cable Age <= 5 Years 2140
3352 Cable Age > 5 Years <= 10 Years 2140
3353 Cable Age > 10 Years <= 15 Years 2140
3354 Cable Age > 15 Years <= 20 Years 2140
3355 Cable Age > 20 Years <= 25 Years 2140
3356 Cable Age > 25 Years <= 30 Years 2140
3357 Cable Age > 30 Years <= 35 Years 2140
3358 Cable Age > 35Years <= 40 Years 2140
3359 Cable Age > 40 Years 2140
3360 UG Cable Failure - Cable Cure 2140
3361 Cable Cure <= 5 Years 2140
3362 Cable Cure > 5 Years <= 10 Years 2140
3363 Cable Cure > 10 Years <= 15 Years 2140
3364 Cable Cure > 15 Years <= 20 Years 2140
3365 Cable Cure > 20 Years <= 25 Years 2140
3366 Cable Cure > 25 Years <= 30 Years 2140
3367 Cable Cure > 30 Years <= 35 Years 2140
3368 Cable Cure > 35Years <= 40 Years 2140
3369 Cable Cure > 40 Years 2140
3400 Miscellaneous - No Special Protection 2500
5060 Overhead Capacitor - 150 KVAR 5050
5065 Overhead Capacitor - 200 KVAR 5050
5070 Overhead Capacitor - Secondary 5050
5100 Overhead Connductors 5100
5000 Overhear Arrestors 5000
5105 Overhead Connductors - 1/0 ACSR Aluminum 5100
5110 Overhead Connductors - 336.4 ACSR Aluminum 5100
5115 Overhead Connductors - 336.4 Hendrix Spacer Cable 5100
5120 Overhead Connductors - 4/0 AWAC Carrier 5100
5125 Overhead Connductors - 636 High Line 5100
5130 Overhead Connductors - 954 High Line 5100
5135 Overhead Connductors - 1590 High Line 5100
5150 Crossarm 5150
5155 Crossarm - 4-Foot 5150
5160 Crossarm - 6-Foot 5150
5165 Crossarm - 8-Foot 5150
5170 Crossarm - 10 Foot 5150
5200 Overhead Cutout 5200
5205 Overhead Cutout - 100 Amp 5200
5210 Overhead Cutout - 200 Amp 5200
5250 Overhead Fuses 5250
5255 Overhead Fuses - Line 5250
5260 Overhead Fuses - Transformer 5250
5300 Anchor 5300
5305 Anchor - Single Flight Helix 5300
5310 Anchor - Three Flight Helix 5300
5315 Anchor - Pole Key 5300
5350 Insulator - Overhead 5350
5355 Insulator - Transmission Bell 5350
5360 Insulator - 10 kV Epoxy Bell 5350
5365 Insulator - 10 kV Porcelain Gray Bell 5350
5370 Insulator - 'C' Neck Brown Pin 5350
5375 Insulator - 'C' Neck White Pin 5350
5380 Insulator - 'F' Neck Gray Pin 5350
5400 Transmission Pole 5400
5401 Transmission Pole - 55-Foot 5400
5402 Transmission Pole - 60-Foot 5400
5403 Transmission Pole - 65-Foot 5400
5404 Transmission Pole - 70-Foot 5400
5405 Transmission Pole - 75-Foot 5400
5406 Transmission Pole - 80-Foot 5400
5407 Transmission Pole - 85-Foot 5400
5408 Transmission Pole - 90-Foot 5400
5409 Transmission Pole - 95-Foot 5400
5410 Transmission Pole - 100-Foot 5400
5450 Distrabution Pole 5450
5451 Distrabution Pole - 35-Foot 5450
5452 Distrabution Pole - 40-Foot 5450
5453 Distrabution Pole - 45-Foot 5450
5454 Distrabution Pole - 50-Foot 5450
5505 Pole Ground - #4 Copper Wire 5500
5510 Pole Ground - 2/0 Copper Wire 5500
5515 Pole Ground - 4/0 Copper Wire 5500
5550 Primary Jumper Wire 5550
5555 Primary Jumper Wire - 4 kV 5550
5560 Primary Jumper Wire - 13.8 kV 5550
5600 Pole-Mounted Terminator 5600
5605 Pole-Mounted Terminator - #2 Elasta Mold 5600
5610 Pole-Mounted Terminator - Cold Shrink 5600
5615 Pole-Mounted Terminator - Porcelin/Glass (Joslin) 5600
5620 Pole-Mounted Terminator - Raychem 5600
5650 Splice connector - 5650
5655 Splice connector - Sleeve (Various Size Wire) 5650
5660 Splice connector -Crimpit (Various Size Wire) 5650
5665 Splice connector -Cu. Chrimps (Various Size Wire) 5650
5670 Splice connector -Cu. Fargo (Various Size Wire) 5650
5700 Switch - Overhead 5700
5705 Switch - Gang Preassembled Fiberglass 5700
5710 Switch - Gang 3-Piece Kit 5700
5715 Switch - Blade Crossarm Mounted 5700
5720 Switch - Blade Inline 5700
5750 Transformer - Overhead 5750
5755 Transformer - 3-Phase Bank (120/208) 5750
5760 Transformer - 3-Phase Bank (240/480) 5750
5765 Transformer - 3-Phase Bank (277/480) 5750
5770 Transformer - 3-Phase Bank (120 W/ Wild Leg) 5750
5775 Transformer - 2400 Volt Single Phase 5750
5780 Transformer - 7960 Volt Single Phase 5750
5785 Transformer - 13800 Volt Single Phase 5750
5800 Hardware (Nuts & Bolts) 5800
5005 3 KV Arrestors 5000
5010 10 KV Arrestors 5000
5015 10 KV Riser Arrestor 5000
5020 69 KV Arrestors 5000
5025 161 KV Arrestors 5000
5050 Overhead Capacitor 5050
5055 Overhead Capacito - 100 KVAR 5050
5500 Pole Ground 5500
4912 Substation Bushings - 13.8 kV 4910
4913 Substation Bushings - 69 kV 4910
4914 Substation Bushings - 161 kV 4910
4915 Substation Capacitors 4915
4916 Substation Capacitors - 4 kV 4915
4917 Substation Capacitors - 13.8 kV 4915
4918 Substation Capacitors - 69 kV 4915
4919 Substation Capacitors - 161 kV 4915
4920 Substation Current Transformers 4920
4921 Substation Current Transformers - 4 kV 4920
4922 Substation Current Transformers - 13.8 kV 4920
4923 Substation Current Transformers - 69 kV 4920
4924 Substation Current Transformers - 161 kV 4920
4925 Substation Fuses 4925
4926 Substation Fuses - 4 kV 4925
4927 Substation Fuses - 13.8 kV 4925
4928 Substation Fuses - 69 kV 4925
4929 Substation Fuses - 161 kV 4925
4930 Substation Insulator 4930
4931 Substation Insulator - 4 kV 4930
4932 Substation Insulator - 13.8 kV 4930
4933 Substation Insulator - 69 kV 4930
4934 Substation Insulator - 161 kV 4930
4935 Substation Potential Transformer 4935
4936 Substation Potential Transformer - 4 kV 4935
4937 Substation Potential Transformer - 13.8 kV 4935
4938 Substation Potential Transformer - 69 kV 4935
4939 Substation Potential Transformer - 161 kV 4935
4940 Substation Protective Relay 4940
4941 Substation Protective Relay - 4 kV 4940
4942 Substation Protective Relay - 13.8 kV 4940
4943 Substation Protective Relay - 69 kV 4940
4944 Substation Protective Relay - 161 kV 4940
4945 Substation Splice/Connection 4945
4946 Substation Splice/Connection - 4 kV 4945
4947 Substation Splice/Connection - 13.8 kV 4945
4948 Substation Splice/Connection - 69 kV 4945
4949 Substation Splice/Connection - 161 kV 4945
4950 Substation Voltage Regulator 4950
4951 Substation Voltage Regulator - 4 kV 4950
4952 Substation Voltage Regulator - 13.8 kV 4950
4953 Substation Voltage Regulator - 69 kV 4950
4954 Substation Voltage Regulator - 161 kV 4950
4955 Substation Miscellaneous Equipment 4955
4956 Substation Miscellaneous Equipment - 4 kV 4955
4957 Substation Miscellaneous Equipment - 13.8 kV 4955
4958 Substation Miscellaneous Equipment - 69 kV 4955
4959 Substation Miscellaneous Equipment - 161 kV 4955
4995 Substation Miscellaneous Hardware 4995
4996 Substation Miscellaneous Hardware - 4 kV 4995
4997 Substation Miscellaneous Hardware - 13.8 kV 4995
4998 Substation Miscellaneous Hardware - 69 kV 4995
4999 Substation Miscellaneous Hardware - 161 kV 4995
4500 Substation Breaker 4500
4505 Substation Breaker- Main 4500
4510 Substation Breaker - Line/Feeder 4500
4515 Substation Breaker - Bus Tie 4500
4520 Substation Breaker - Generator 4500
4525 Substation Breaker - Station Service 4500
4550 Substation Bus 4550
4555 Substation Bus - Open Air 4550
4560 Substation Bus - Enclosed 4550
4565 Substation Bus - Duct 4550
4600 Substation Switch 4600
4605 Substation Switch - Gang 4600
4610 Substation Switch - Blade 4600
4615 Substation Switch - Motor Operated 4600
4620 Substation Switch - Other 4600
4650 Substation Transformer 4650
4655 Substation Transformer - 161/69 kV W/ Supv. LTC 4650
4660 Substation Transformer - 69/13.8 kV W/ Auto. LTC 4650
4665 Substation Transformer - 13.8/4 kV W/ Auto. LTC 4650
4900 Other Substation Equipment 4900
4905 Substation Arrestors 4905
4906 Substation Arrestors - 4kV 4905
4907 Substation Arrestors - 13.8 kV 4905
4908 Substation Arrestors - 69 kV 4905
4909 Substation Arrestors - 161 kV 4905
4910 Substation Bushings 4910
4911 Substation Bushings - 4 kV 4910
4100 Unit 9 FGD 4100
4150 Material Handling 4150
4155 Barge Unloader System 4150
4160 Rail Car Unloader System 4150
4165 Coal Conveyor System 4150
4000 Boiler 4000
4005 Unit 7 Boiler 4000
4010 Unit 8 Boiler 4000
4015 Unit 9 Boiler 4000
4050 Generator 4050
4055 Generator - Unit 7 4050
4060 Generator - Unit 8 4050
4065 Generator - Unit 8A 4050
4070 Generator - Unit 9 4050
6000 Arrestor - Underground 6000
6005 Arrestor - Elbow 6000
6010 Arrestor - Parking Stand 6000
6015 Arrestor - 10 kV Riser 6000
6050 Cable - 15 kV Underground 6050
6055 Cable - 15 kV #2 6050
6060 Cable - 15 kV 4/0 6050
6065 Cable - 15 kV 750 KCMIL 6050
6100 Elbow Connector 6100
6105 Elbow Connector - #2 6100
6110 Elbow Connector - #2 (Extra Long) 6100
6115 Elbow Connector - 4/0 6100
6120 Elbow Connector - 750 KCMIL 6100
6150 Foundation 6150
6155 Foundation - Transformer Poly Pad 6150
6160 Foundation - PMH-4 Switchgear 6150
6165 Foundation - PMH-9 or PMH-11 Switchgear 6150
6200 Fuses - Underground 6200
6205 Fuses - For SM-4 Style Holder 6200
6210 Fuses - For Trayer Gear 6200
6215 Fuses - RTE Bay-O-Net style (For PDM Transformer) 6200
6250 PDM Ground - Underground 6250
6255 "PDM Ground - 5/8"" X 8' Ground Rod" 6250
6260 PDM Ground - Crimp, Copper Ground Pad Connector 6250
6265 PDM Ground - Bolt-Up Connector 6250
6300 PDM Trtansformer 6300
6305 3-Phase PDM Trtansformer - (120/208) 6300
6310 3-Phase PDM Trtansformer - (240/480) 6300
6315 3-Phase PDM Trtansformer - (277/480) 6300
6320 2.4 kV Single Phase PDM Transformer 6300
6325 8 kV Single Phase PDM Transformer 6300
6330 13.8 kV Single Phase PDM Transformer 6300
6350 Switchgear 6350
6355 Switchgear - PMH-4 6350
6360 Switchgear - PMH-6 6350
6365 Switchgear - PMH-9 6350
6370 Switchgear - PMH-11 6350
6375 Switchgear - Trayer PMH-9 Configuration 6350
6380 Switchgear - Trayer PMH-11 Configuration 6350
6400 Splice Connector - Underground 6400
6405 Splice Connector - #2 6400
6410 Splice Connector - #2 Long 6400
6415 Splice Connector - 4/0 6400
6420 Splice Connector - 750 KCMIL 6400
6500 Terminator - Underground 6500
6505 Terminator - #2 Cold-Shrink 6500
6510 Terminator - 4/0 Cold-Shrink 6500
6515 Terminator - 750 KCMIL Raychem Connector 6500
6520 Terminator - #2 Stress Cone Connector 6500
6525 Terminator - 4/0 Stress Cone Connector 6500
6530 Terminator 750 KCMIL Stress Cone Connector 6500
7000 Customer-Owned Guy/Anchor 7000
7005 Customer-Owned Meter Loop 7005
7010 Customer-Owned Pole 7010
7015 Customer-Owned 3-Phase OH Secondary 7015
7020 Customer-Owned Single Phase OH Secondary 7020
7025 Customer-Owned Splice/Connection 7025
7100 MPW-Owned Guy/Anchor 7100
7105 MPW-Owned Meter Loop 7105
7110 MPW-Owned 30' Service Pole 7110
7115 MPW-Owned 3-Phase OH Secondary 7115
7120 MPW-Owned Single Phase OH Secondary 7120
7125 MPW-Owned Splice/Connection 7125
7200 Other Utility's Guy/Anchor 7200
7205 Other Utility's Service Pole 7205
8000 Customer-Owned Meter Pedestal 8000
8005 Customer-Owned 3-Phase Undergroud Secondary 8005
8010 Customer_Owned Single Phase Underground Secondary 8010
8100 MPW-Owned Meter Pedestal 8100
8105 MPW_Owned 3-Phase Underground Secondary 8105
8110 MPW-Owned 4/0-4/0-2/0 Single Phase UG Secondary 8110
8115 MPW-Owned 350-350-4/0 Single Phase UG Secondary 8115
8120 MPW-Owned UG Secondary Pedestal 8120
8125 MPW-Owned UG Service Splice (Torpedo) 8125
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top