Dear friends,

 

I have two tables. In the first table a field contains two different type of values such as "A1234xxxxx..." and "1234xxx..." (where x is a random number) and a field in other table contains values such as "A1234"

 

I want to link these two tables in order to get same results in table 2 for the both types of values such as "A1234xxxxx..." and "1234xxx..." in my formulas. Can you help me to do it?

 

For example

 

Table1

field1:

A123411

A1234690737

A12343973

123456

1234090832323

A987611

A98768307297

98763237829

987632735

 

Table2

field1   -  field2

1234   -    VALUE1

9876   -    VALUE2   

4566   -    VALUE3

 

And after linking i want to use such a formula to get the field2 values

 

IF RIGHT (LEFT ({TABLE1.FIELD1}, 5), 4) = {TABLE2.FIELD1} THEN

    FORMULA = {TALBE2.FIELD2}

END IF