How do I...?

Is there a way to select records in a table that are not linked to any other table

I have a table of people who completed volunteer applications and a table of various volunteer jobs and a many to many link to link the volunteers to the activities they actually performed. That is working fine. I want to find all the people on the table of people who completed a volunteer application who have never volunteered at all. Is there a way to do that?

1 vote
Vote
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
You have left! (?) (thinking…)
Linda shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

1 comment

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...
  • Derrick Kotlus commented  ·   ·  Flag as inappropriate

    Hello Linda,

    Unless there is a field in the table that identifies whether or not the volunteer has completed an activity, you will need to use table relationships to get this figure. You can use the count() function to see how many child records (activities) that a volunteer has completed. Below is a great article on child functions for you to take a look at. Hope this helps!

    http://help.trackvia.com/knowledgebase/articles/356703-child-functions

    Derrick

Feedback and Knowledge Base