problem with concat label

[icreas]

Hello to all the two I have a problem with the label concat - I put a formula that does not go (it joined copy of screen) has place of the 1, it should resorte the name of the country of my list country attached copy thank you for your help

 

[cheesegrits]

Assuming 'country' is a join from the city table to a country table, you'll need to look up that foreign key in the other table ...

{thistable}.city, ', ', (SELECT country FROM countries WHERE id = {thistable}.country)

Replace the country table / field names to suit.

-- hugh

 

[icreas]

problem no good please help me thank you

 

[icreas]

capture screen

 

[cheesegrits]

You'll need to show the setup of your Country table.

-- hugh

 

[icreas]

hello thank you for your assistance capture screen following regards

 

[cheesegrits]

OK, so the table name is genea17_countries, but in the concat query you still have just countries.

Sent from my HTC 10 using Tapatalk