Jump to content

Match a word to another table's contents?


This topic is 7195 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

Hey guys,

I'm relatively new to Filemaker, so I'd greatly appreciate any help:

I have a table called 'Articles' with about 2000 records of publications with a field that contains addresses. Those addresses have within them the country name, although not always in the same place. I also have another table with the names of every country. I would like to be able to perform a count of the Articles that were written in each country. (Eg: 'Canada = 13 articles, Ireland = 4 articles and so on) by seeing if any of the countries in the 'Countries' table is a match anywhere in the address field for all the 'Article' table records.

Could anyone point me in the right direction? Thanks a lot!

Simon Rascovsky MD, M.Sc

Link to comment
Share on other sites

Simply define an relationship from "Countries" table to "Articles" table country-->address.

Then create an calculation field (in Countries table)

Count(TheAboveRelName::nameOfSomeNonEmptyFieldInArticlesTable)

Dj

Link to comment
Share on other sites

This topic is 7195 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.