Re: Tabel relationships window

Tech-Archive recommends: Fix windows errors by optimizing your registry

Craig

In addition to Allen's suggestions, the way in which you "delete" may be why
you are seeing what you're seeing.

In the relationships window, deleting a table doesn't delete the table's
relationship(s). You have to delete the relationship (joining lines) before
deleting the table, or it won't "stay put".

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP
http://mvp.support.microsoft.com/

Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/


"Craig Ugoretz" <CraigUgoretz@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5B9E1028-6CF9-4F94-B13C-7488DAB21490@xxxxxxxxxxxxxxxx
This is maybe hard to explain, but I have table relationships in mind such
as
one-to-one or one-to-many between tables in my database. I enter the
relationships in the table relationships window, but I notice in certain
instances I can not create relationships between tables uinless I create
copies of tables. After I create the copies, exit the table relationships
window, and come back, tables and/or relationships disappear, or extra
relationships appear. This appears very weird. Futhermore, if I delete
all
the tables in the window and start over with displaying new tables, the
relationsiphs previously entered between the tables come back. That too
is
weird, in my opinion. I would like things to "stay put".


--
Craig ugoretz

.

Relevant Pages

  • Re: Panic
    ... >I have looked at my relationships again and I have 2 multiple extra tables ... >These were showing in my relatioship view yesterday and I simply deleter the ... Deleting the table icon just changes the display, ... relationships window - not either table, but the line between them - ...
    (microsoft.public.access.gettingstarted)
  • Re: Deleting fields from table
    ... actually deleting the relationship. ... Open the Tools|Database Documenter, ... Microsoft Office/Access MVP ... have gone to the relationships window and removed the connection. ...
    (microsoft.public.access.gettingstarted)
  • Re: Cannot delete relationships
    ... You may be just deleting the tables from the relationships window, so they are not part of the view. ... Perth, Western Australia ... Tips for Access users - http://allenbrowne.com/tips.html ...
    (microsoft.public.access.tablesdbdesign)
  • Re: deleting relationships
    ... When you view the relationships window, ... Selecting and hiding a table or deleting it from the relationship ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Cant delete relationships
    ... with MSsysObjects? ... Have you opened the relationships window, highlighted a relationship, ... Jeff Boyce ... Microsoft Office/Access MVP ...
    (microsoft.public.access.tablesdbdesign)