Relation doesn't work

Panorama X
1

I made a simple relation Invoice contacts (ID-ID key fields) in invoice I don’t have all the fields but I use a formula that works in formula workshop:

related({Adresse+cr()+Ville+“, “+Province+cr()+Pays},“ContactsJames”)+ignore(””,ID)

when I use in a text display I have a message : field or variable Adresse does not exist???

I try to change the name but nothing.

2

If the formula works in the Formula Workshop it should also work in a Text Display object. There must be some additional detail that you are not communicating to us.

3

the text display was not in formula mode. I just find it. thank you.