AnsweredAssumed Answered

Find Inactive Records

Question asked by EssexBiker on May 18, 2018
Latest reply on May 18, 2018 by EssexBiker

Amongst the many related tables that I have in my DB, there are Student and Orders.

With our new, lovely GDPR regulations here in the EU we can't hold onto personal data longer than we really need to.

 

Relevant fields are :

STUDENT

pk_StudentID

 

ORDERS

Valid From (Date Field)

Expires     (Date Field)

fk_StudentID

 

How could I find the inactive/ latent Students that have not had an order since a specified date?

If I could find these, I could delete the records, en mass.

Outcomes