Problem with relationship over three db

[BobWeaver]

You can have a TownID field in the inscription file that is set to the same TownID as in the client file. Then create a direct relationship to the town file. Then you can display the town name using this relationship.

Alternately, you can create a town name field in the client file which is an auto-enter value looked up from the town file based on the Town ID relationship. You can then access this field in the inscription file.

[JohnC#]

i have three db:

1 for the town

1 for the client

1 for an inscription for a client

--town.fp5 contain two field: town_id and town_name

--client.fp5 contain a field town_id with a relationship with the town_id of town.fp5. So at this level, I can obtain the town name.

--inscription.fp5 refer to a specific client by the client_id. But when I want to display the town name, i'm stuck... I can only display the town_id.

Do you understand my problem :?