AnsweredAssumed Answered

Multi-value criteria

Question asked by WiserGuy on Sep 10, 2014
Latest reply on Sep 10, 2014 by WiserGuy

Title

Multi-value criteria

Post

Hi,

I am streamlining an old certification database and have a question about multi-value criteria, I was hoping for some help with.

         
  • tbItems::SerialNo
  •      
  • tbCerts::ID
  •      
  • tbCerts::SerialNo (relation to the above)
  •      
  • tbCerts::CertType
  •      
  • tbCerts::CertDate
  •      
  • tbCerts::DueDate
  •      
  • tbCerts::ReCert

For one particular item, I can have a list with 50 certificates over the year of various certificate types. The reason for checking the ReCert checkbox is to be able to filter out items which has had the specific certification type recertified, but keeping them in the table.

If we add a new certificate and there is already an older certificate with the same certificate type, we check the old one manually.

I'm sure there is a way to check this box automatically if certain criterias are met, I'm thinking of something like:

         
  1. Checking all records with same SerialNo and CertType in tbCerts
  2.      
  3. If CertDate for a CertID is older than one that match the above, then check CertRecert

Would be great if someone could help me with a script, or feel free to point me to other ways of doing this.

 

Regards,

WG

Outcomes