I am having building the correct join tree in Foxfire V6.02 for a set of relations. Basically what I have is:

Estimate
|
|---->Summary (Film)
| |
| |-->City (CityID)
| |
| |-->Terrcode (Terrid)
|
|-->Terrcode (Terrid)
|
|
|-->Film (Filmid)


The problem is on the terrcode table. I need it to be linked in twice.

Thanks for any help.

Perry