How do you Delete and Create Relationship from Code?

I need to severe a relationship so that i can run a make table query. Doens't work if there is a relationship.

Bruce

Look at relations collection and CreateRelation Method Example in online
help

--
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com


"Bruce" <(E-Mail Removed)> wrote in message
newsE70E0D2-022F-4890-9AA7-(E-Mail Removed)...
> How do you Delete and Create Relationship from Code?
>
> I need to severe a relationship so that i can run a make table query.
Doens't work if there is a relationship.
>
> Bruce

"=?Utf-8?B?QnJ1Y2U=?=" <(E-Mail Removed)> wrote in
newsE70E0D2-022F-4890-9AA7-(E-Mail Removed):

>
> I need to severe a relationship so that i can run a make table query.
> Doens't work if there is a relationship.
>
>

This does not make sense: making a new table cannot have any effect on
existing tables and relationships. If you are deleting an old table prior
to repopulating it, you could simply empty it instead:

DELETE FROM MyTable WHERE TRUE;

(yes, the criterion is redundant, but reminds people that it is a
potentially devasting command!). The advantage of this is that it's quicker
and does not disrupt the database as you have found. It will also
automatically pick up any referential violations amongst the imported
records.

Hope that helps


Tim F