I am streamlining an old certification database and have a question about multi-value criteria, I was hoping for some help with.
- tbCerts::SerialNo (relation to the above)
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:
- Checking all records with same SerialNo and CertType in tbCerts
- 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.