freezing the Relationship diagram

Hi Christopher,

Are you using lookup function on the table definition?

http://www.mvps.org/access/lookupfields.htm

You should implement lookup function on forms.


Immanuel Sibero



"Christopher Glaeser" wrote in message
...
I thought perhaps I had corrupted my database, so I started from scratch
by
creating a new database and importing only the tables (no relationships).
I
opened the Relations window, created the links, closed the Relations
window,
then opened the Relations window. Tables with multiple links like
tblStatus_1 and tblStatus_2 were orphaned, and the links were redrawn to
tblStatus. My beautiful diagram was converted to speghetti. As best I
can
tell, this is a "feature" of Access. How do Access developers view the
relations of a complex database?

Best,
Christopher

What would you recommend is such situations?

This information came too late for me! I still don't know
if I had problems with the SQL or if the query really was
non-updatable for some reason. But I guess what I would
recommend is turning off the auto-join feature for query
design, and doing all your own joins when you add a table
to a query.

(david)


"Christopher Glaeser" wrote in message
...
Remember that the automatic join procedure when creating
queries in design view uses the same list of FK indexes
that the relationship view uses: if the relationship
window gets confused about how to draw relationships,
the query design helper will suffer from the same confusion.

Yep, I finally got one last night when designing a new query.

The result is that the SQL may include joins that are not
immediately apparent from the query design view window.
Unexplained non-updatable queries are a common result.

What would you recommend is such situations?

Best,
Christopher

Are you using lookup function on the table definition?

http://www.mvps.org/access/lookupfields.htm

You should implement lookup function on forms.

Thanks for asking, but no, I have not used any lookup functions in any of
the tables.

Best,
Christopher