martinc

Negative Testing...find what's missing

Discussion created by martinc on Jan 17, 2013
Latest reply on Jan 17, 2013 by martinc

We use: fmsa 11 on WinServer 2008 with users on Win XP using fmp11, I use fmpa11 mostly on windows

 

Part of our system holds a training table to log training events. I'm pretty solid on finding what we Do have. I having a challenge on finding what we Dont have..

 

We have a few tables that relate to this

Employees

Classes

Training Events

 

We create a training event and link a classs to it as well as the employees that attended. Pretty cool. I can see related events on a particular employees record.

What I really want to see is what's MISSING.

 

Example: There is a class for xyz and I want all employess of job title 123 to take this class once per year. I'd like to know at a glance who needs to still take xyz class. How do I search for non-existent related records?

 

Thanks

eeFile.jpg

 

Martin

Outcomes