There's no debugging involved. You are trying to include a Memo field in a join or relationship. Access 97 (Jet 3.5) doesn't do that.
Access 2000 (Jet 4.0) or later will join on the first 256 characters of a Memo field, so you could perhaps upgrade. Other than that, you need to take the memo field out of the JOIN clause or relationship.
It may be possible to obtain the results you want at the time you use the relationship, by matching the memo fields in your criteria or WHERE clause. This will depend on the details of your tables, their keys, and what your intent is at the time.
Rick Sprague
Want the best answers? See faq181-2886
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein