Make table query and Table Relationships (Notify Me)

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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?
 
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!
 
Back
Top