>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
Have you tried setting up the second link up with a different alias name referring to the same physucal table.
Bill N.