Can't join on Memo or OLE Object <name>. (Error 3118)

You cannot join Memo or OLE Object fields. The field you use to logically tie two or more tables together must be some other data type, such as text or integer.