Human Resources file. Each employee has different licenses/certifications we need to keep track of. I have set up a FileBank table and layout that allows a user to upload files. HR::pkID-<FileBank::fkID
I can't figure out a way to track certifications that are expiring. I can add FileBank::Expire field to track when a certification is going to expire and display in a portal on a dashboard layout, but I feel the Expire field should be part of the HR table. And when a new certificate is obtained and uploaded, the expired date needs to change.