Make table query and Table Relationships (Notify Me)

[Guest]

I have three tables: Clients, Clients_1 and Interest Current.
Relationships:
1> Clients and Interest Current:
The Clients table is the "table" (left) and the Interest Current is the
"related table".
The common field name is CaseName
2> Clients_1 and Interest Current:
The Clients_1 table is the "table" (left) and the Interest Current is the
"related table". The common field name is ClientNo
In both of the above relationships:
a> Enforce referential integrity, Cascade update and delete related fields
are checked.
b> relationship type is one-to-many
c> join property is #2

Problem:
I want to run a make table query that deletes the Interest Current table to
replace it with the new Interest Current table via the query. When I run
the query I get a message that "the table can not be deleted because of
excisting relationships. If you want to delete this table first delete the
relationships".
How can I use a macro/vba to automate:
1> deleting the relationships before I run the query, then
2> run the query, then
3> recrate the relationships

 

[Douglas J. Steele]

While it is possible to do what you're asking for, would it be easier to
just delete the data from Interest Current, rather than deleting the table
itself?

 

[Guest]

Thanks for the response.
Since you mentioned "delete the data from the table" I wondered how to do
that and found the "delete query", which takes care of my problem.
Thanks again!