UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

> Ok To Delete/change Relationships In A Query?, Access 2010 Web    
 
   
Metron4
post Mar 28 2012, 04:09 PM
Post #1

UtterAccess Addict
Posts: 114



Hi,

In my web database I was getting unpredictable results with my query. Certain results that displayed as expected would suddenly be filtered out when I added another table. I noticed the relationship of the new table had redundant joins to other tables, so I deleted them. Now my query looks as it should.

Am I correct in assuming that changing or deleting the table relationships shown in the query design have no effect on the relationships of the tables outside the query?

Thanks
Go to the top of the page
 
+

Posts in this topic


Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 



RSS Go to Top  ·  Lo-Fi Version Time is now: 19th June 2013 - 05:32 PM