Relationships

  • Thread starter Thread starter gr
  • Start date Start date
G

gr

Hi, I just realized that in my Relationships window I have
a copy of a table (original name: tblPeople, copied as
tblPeople1) and tblPeople1 has as well the same
relationships that tblPeople has to other tables. Is
necessary to keep this tblPeople1 and it's relationships?
can I delete it and all the relationships? Why this copy
was created?

Thx.
 
One possibility is that your table includes fields defined with the "lookup"
data type.

For these "duplicates", have you tried clicking on the joining line,
deleting it, and then deleting the table (in the Relationships window)?

And if you have any lookup data type fields, consider changing them to the
appropriate data type for a foreign key (i.e., Long for Autonumber, Text for
Text, etc.).

Good luck

Jeff Boyce
<Access MVP>
 
Yes, I can delete them, mainly the question is if there is
a secondary (undesired) effect of doing this.

thx.
 
That would really depend on whether your queries, forms, etc. are based on
the "...1" versions, and even then, the Relationships windows doesn't touch
the actual tables. All those with "...1" are simply showing a copy of the
original, to make it easier (?!) to see relationships.
 
Yes, I can delete them, mainly the question is if there is
a secondary (undesired) effect of doing this.
Click to expand...

If they are really duplicate relationships - i.e. between the same
pair of fields in the same pair of tables - there is no reason to keep
them, and you'll prevent database bloat and get faster performance if
you do delete them. Note that you need to select the *join line*, not
the table icon, and delete it; once the redundant table icon is
disconnected, it can safely be deleted. Deleting the icon just hides
it and does not remove the unneeded relationship.
 
Back
Top