>Hi Naomi.
>
>>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?
>
>You put whatever goes into the JOIN clause of a SQL statement. Remember to alias the tables. So, you'd use something like ChildTable.Field = Codes.Code AND Codes.TypeField = "SOME TYPE".
>
>Doug
Yes, figured this afterwards.
If it's not broken, fix it until it is.
My Blog