Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Base report data field formula for 2 tables

I have a database with two tables:

  • "Friends" (Name, CountryID)
  • "Countries" (ID, Country)

I want to build a report displaying a list of friends names and relative country (USA, Italy, France...) instead of country ID.

Which formula I have to use in Data field of "Country" Text Box properties?
Is SQL allowed?
I tried SELECT "Country" FROM "Friends" JOIN "Countries" ON "ID" = "CountryID" but it doesn't display anything in the report ☹

Thank you!