Prev: Stopping a macro based Setwarning diag box
Next: Getting a loading solution for our business
From: P. Bolden P. on 6 Apr 2010 12:08
I have erroneously created a table that I do not need. I need to connect a
relationship between two other tables but this one is in the way. Can you
tell me how do I get rid of it?
From: Stephen Raftery on 6 Apr 2010 12:23
What is preventing you from just deleting it ?

Stephen


"P. Bolden" wrote:

> I have erroneously created a table that I do not need. I need to connect a
> relationship between two other tables but this one is in the way. Can you
> tell me how do I get rid of it?
From: Jeff Boyce on 6 Apr 2010 12:26
Open the db. Go to the tables window. Highlight the table. Hit <delete>.

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.


"P. Bolden" <P. Bolden(a)discussions.microsoft.com> wrote in message
news:A40AC487-1E09-40B8-8770-FF0BF3578A6B(a)microsoft.com...
>I have erroneously created a table that I do not need. I need to connect a
> relationship between two other tables but this one is in the way. Can you
> tell me how do I get rid of it?


From: Clif McIrvin on 6 Apr 2010 13:22
"P. Bolden" <P. Bolden(a)discussions.microsoft.com> wrote in message
news:A40AC487-1E09-40B8-8770-FF0BF3578A6B(a)microsoft.com...
>I have erroneously created a table that I do not need. I need to
>connect a
> relationship between two other tables but this one is in the way. Can
> you
> tell me how do I get rid of it?


Sounds like you might be talking about the graphical relationships
window ...

If so, you have at least three options:

1. Let the relationship line go "through" the third table graphic.
2. Right click in the third table's title bar and click "Remove Table"
3. Drag the third table's graphic out of the way.

or .. as others have advised, simply delete the unwanted table ...
assuming, of course, that it really is an unneeded table, and not just a
graphic where you don't want it.

Clif


 | 
Pages: 1
Prev: Stopping a macro based Setwarning diag box
Next: Getting a loading solution for our business