If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
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 |
#12
|
|||
|
|||
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 |
#13
|
|||
|
|||
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 |
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Re-establishing a broken relationship | David McKnight | Database Design | 2 | December 1st, 2004 10:49 AM |
Relationship Diagram | lt | Setting Up & Running Reports | 0 | July 8th, 2004 01:58 PM |
Setting dual relationship with tool connector | Carlos | Visio | 0 | May 20th, 2004 12:51 AM |
Curve diagram | Snedker | Charts and Charting | 3 | November 28th, 2003 11:01 AM |