Hi everybody,

We have some complex relations between tables. One table is called Codes and it has TYPE, CODE, Description fields.

We need to join two tables based on Field=Codes.Code and Codes.Code = "SOME TYPE"

I see in Stonefield DataDictionary a memo field to define the complex join, but it doesn't tell me what should I put into it. Just AND condition?

That's what I tried, but got an error.

I'm wondering if somebody knows the answer on this question while I try to look in the manual.

Thanks in advance.