Field Relationships

Hello and thank you in advance to anyone who may assist me.
This will be the first of a few posts I will be making.

I am trying to query data between 4 tables (Line, Load, Fuse, Recloser).

The fields I'm attempting to join are:
Line!STR_ID
Load!NAME
Fuse!STR_ID
Recloser!STR_ID

My problem is that no exact unique identifier field exists between the
tables in these fields. But there is a five-digit circuit number buried
within each these fields that match up. i.e. STR_ID= "Z12345-7788996" the
circuit number is always before the hyphen so in this case it is "12345".

The proceeding numbers vary within the fields along with the leading
alphabetic character. Is there any possible way to join these tables so I
may extract data?

Or...
The only way I have thought possible so far is to make another field within
each table. By doing this I'd copy and paste each field listed above into
Excel and find a way to grab the circuit number out of the data. I know
there is a way to do this as well but I can't remember.

Please help ASAP!

Thanks.

--
Nadia
.

Relevant Pages