added tables

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

Guest

I am trying to organize relationships and joins. There are tables that are
on the relationship page that dont exist. Thet have the base name of an
existing table with an added "_1" For instance, a legitimate tabe is
"Orders", I have that table and also one named Orders_1. Whats up with that?
 
Access will often do that, rather than having relationship lines cross in
the diagram. The Orders_1 "table" is really just a pointer to the Orders
table.
 
I am trying to organize relationships and joins. There are tables that are
on the relationship page that dont exist. Thet have the base name of an
existing table with an added "_1" For instance, a legitimate tabe is
"Orders", I have that table and also one named Orders_1. Whats up with that?
Click to expand...

Orders_1 is just an "alias" for Orders. It's not a new table; it's
just a second icon for the same table. You will get this new icon if
you have two different relationships from the (e.g.) Parts table to
the Orders table. This is occasionally legitimate (for example, you
might have a SubstitutePartNo in the Parts table, and be able to order
either a Part or a SubstitutePart), but typically it means you have
been victimized by Microsoft's infuriating Lookup Wizard misfeature;
this will create a new relationship for the lookup field, even if a
valid relationship already exists.

To remove the extraneous table icon (if it is in fact redundant),
select the Join Line - *NOT* the table icon! - in relationships; click
the Delete key to remove the relationship; and only then delete the
"orphan" icon.


John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top