I have 200 students in tblstudent
They are linked to other information such as assessments
When I want to update my list of students (it changes once a week), I cannot just delete old and replace with new as the links with other tables prevent this.
Is there a work around without removing referential integrity.
Many thanks