[Hfreelance]

I have 5 tables in the database that are used to store the employee registration system. Every two weeks there is a file which contains updates to the employee records, i.e. new employee data, terminated employee data, changes to different accounts for employees, etc. I have a set of steps which must be executed to import this file and extract and update the data in the registration tables.The import data is not in the correct format for the data base, so I must manipulate it before the table updates can occur. As a result, I have created realtionships between the import file and the existing tables. Each time the table is imported, the relationship between the existing import table must be deleted, the file imported, the realtionship reestablished, manipulate the import data, and the registration tables get updated. I am trying to find a way to programatically remove table relationships and add table relationships. I believe I have the other steps figured out.

Thank you for your help!

[OBP]

Why do you need to delete the Relationship to the New data file. In fact why do you need a relationship to it in the first place?
If it is a temporary file it may not be necessary to have a relationship at all.