Re: Panic

From: John Vinson <jvinson@xxxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Thu, 02 Jun 2005 10:35:20 -0600

On Thu, 2 Jun 2005 03:33:07 -0700, "MitziUK"
<MitziUK@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

>John
>
>I have looked at my relationships again and I have 2 multiple extra tables
>'makes_1' and 'models_1'
>
>These were showing in my relatioship view yesterday and I simply deleter the
>table from the window, but they appear again today, what can I do to get rid
>of them please?

Deleting the table icon (Models_1) just changes the display, not the
relationship.

To delete the redundant relationship, select the *join line* in the
relationships window - not either table, but the line between them -
and click the Delete key. Access will ask if you want to permanently
remove the relationship; if it is (as I guess) a duplicate
relationship, then you can safely say Yes.

Compact the database after you're done deleting the excess
relationships, and test thoroughly to be sure everything's still
working. If it's not, you *did* save a backup... right? <g>

John W. Vinson[MVP]
.

References:
- Panic
  - From: MitziUK
- Re: Panic
  - From: John Vinson
- Re: Panic
  - From: MitziUK

Prev by Date: Re: Lookup Values
Next by Date: Conditional Formatting
Previous by thread: Re: Panic
Next by thread: Re: Query to return last record
Index(es):
- Date
- Thread

Relevant Pages

Re: #Deleted
... > I have a form that is showing 3 filtered records and I've created a ... Presumably your button is deleting the record by running a delete query ... different operation -- by executing the statement ...
(microsoft.public.access.forms)
Re: deleting comments when you need to save text changes
... It sounds like you are really deleting them, too. ... If a second doc does NOT do this, try the Corruption fixes on the first doc: ... Workaround--Accept All Changes in the doc of it, then use the Tools Compare Documents function to compare your edited doc to the original doc. ... This should produce a new doc showing all the changes you made, which you can send to the client so that this issue isn't a roadblock. ...
(microsoft.public.mac.office.word)
Re: Tabel relationships window
... In the relationships window, deleting a table doesn't delete the table's ... Microsoft Office/Access MVP ... window, and come back, tables and/or relationships disappear, or extra ...
(microsoft.public.access.tablesdbdesign)
Search Still Shows Deleted Docs
... perticular document in the search result. ... how to display the master documents insted ... >Does anyone know why after deleting a document library ... >to the index yet they are still showing up. ...
(microsoft.public.sharepoint.portalserver.development)
Re: Gantt View Current Date
... Ronnie wrote: ... default to showing the current week but 5 weeks earlier. ... I've tried deleting the Gantt View from the project and using the global one again which works once but when you reopen the file it doesnt default to the current week. ...
(microsoft.public.project)