NEAR APCH TO WRONG ARPT. RADAR VECTORING IN TRAIL.

Narrative

ON DAY 2 OF A LONG; HARD MIL ORI (OP READINESS INSPECTION) EXERCISE MY CREW OF 6 IN A C141 TRANSPORT WAS ON VECTORS FROM FAYETTEVILLE APCH FOR POPE AFB. THERE WAS A CUMULO NIMBUS WITH RAIN SHAFT JUST NW OF THE FIELD; AND ANOTHER SW NEAR THE LARGE RESTRICTED AREA SW OF POPE. APCH ASKED IF WE WOULD ACCEPT VECTORS ALL THE WAY AROUND THE FIELD FOR A R BASE VISUAL TO LAND TO THE NE. AFTER AVOIDING RADAR RETURNS (MY COPLT WAS FLYING; I WAS WORKING THE RADAR/ATC AND GETTING VECTORS IN A 270 DEG TRIP AROUND THE FIELD) WE WERE TOLD TO FOLLOW A C130 AHEAD. MY COPLT SAW HIM TURN BASE TO WHAT HE THOUGHT WAS POPE; BUT WAS ACTUALLY SIMMONS AAF; ANOTHER MIL FIELD NEXT TO POPE. HE TURNED BASE TO THAT FIELD; AND AT THE SAME TIME I REALIZED OUR MISTAKE ALONG WITH POPE TWR WHO RESPONDED TO OUR CALL THAT WE LOST SIGHT OF THE C130 WITH INSTRUCTIONS TO CONTINUE TO POPE. WE WERE ALREADY ROLLING OUT OF THE CORRECTIVE TURN; AND WOULD HAVE LANDED OK AT POPE; EXCEPT THAT TWR SENT US AROUND FOR TFC BEHIND US. WE WENT BACK TO FAYETTEVILLE; AND LANDED AT POPE. A CALL TO THE TWR RESULTED IN NO ACTION OR INCIDENT DISCUSSION. FACTORS: 1) WX -- TSTMS; 2) DIFFERENT; EXTENSIVE AVOIDANCE VECTORS; 3) MULTIPLE LONG DUTY DAYS; NIGHT FLYING; 4) COMPLACENCY.