I need to Create a script to automatically add/delete records in a Dbase via a relational link.

I have sett up a relational database to allow staff at the college that I teach at to input data for centralised record keeping.

What I can't seem to do is create a script that will on start up check the records in my master file of students and will then add/delete records based upon what it finds in the master file.

I am probably missing the obvious here but if anyone has a useful suggestion for doing this I would be very grateful.

I want to make it idiot proof so that staff don't have to add delete records from the database.

------------------

Andrew.

The key is the process you are trying to perform. Are you setting a single field in your Students file? Is some threshold being reached?