Panic

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

Guest

I'm panicking, I look at other peoples database and they don't have so many
relationships. Is this normal?
 
What is your question? We can't see your database or the "others" you
mention. What is "so many" relationships?

If you would like to post the structure of your database and ask us if it
follows normalization rules, we may be able to answer you. You would need
to share your table structure and the relationships you have defined.
 
I'm panicking, I look at other peoples database and they don't have so many
relationships. Is this normal?
Click to expand...

<Hitchiker's Guide> Don't panic! </Hitchiker's Guide>

The right number of relationships for your database is... the right
number of relationships for your database. As Albert Einstein said
about theories, "a theory should be as simple as possible - but NO
SIMPLER!"

That said - if you open your Relationships window, select the View All
button, and see any more than a couple of unlinked "orphan" tables,
you probably have too few relationships. If you see multiple "extra"
tables with names consisting of real table names with _1 and _2
appended, then you may have redundant extra relationships. These can
be created by the Lookup Wizard, which will merrily create a new
relationship to the Lookup table, even when such a relationship
already exists (only one of many flaws in this feature, see
http://www.mvps.org/access/lookupfields.htm for a critique).

As suggested - please post some details. You may be just fine; at the
worst you may want to (carefully, judiciously, backing up your
database first) select some Join lines and delete them.

John W. Vinson[MVP]
 
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?
 
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?
Click to expand...

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]
 
Back
Top