Hi there,
was wondering if there is way to link tables in Microsoft Access, if the primary key is not matching 100%, for example lets assume that we have two table, with fruit type as their content.

Table1
FruitType
ORANGE
APPLE
PEAR

Table 2
FruitType
ORAN
PPLE
EAR

as you can see the content in the second table is somewhat incomplete or corrupted "Orange" is missing an "E", "Apple" is missing an "A", and "Pear" is missing a "P".

Thanking in advance

You could replace each instance of the fruit with a number in both tables therefore:
ORANGE = 1
APPLE = 2
PEAR = 3

ORAN = 1
PPLE = 2
EAR = 3