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

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
> Relation Ship Question, Any Version    
 
   
access2009eg
post Mar 11 2012, 04:55 AM
Post #1

UtterAccess Guru
Posts: 860



friends
what is the best designing relation ship in main access windows or wait and create relation ship in query?



Go to the top of the page
 
+
Peter46
post Mar 11 2012, 06:01 AM
Post #2

UtterAccess VIP
Posts: 7,394
From: Oadby Leics, UK



You use both of these because they are not the same.

Relationships define rules for how records are stored and maintained in tables. So you should use these to ensure integrity of your data.

In queries you create JOINS not relationships. Joins are used to extract and display related data. They do not affect how data is stored in the database. If you add tables to the query design grid, then Access ASSUMES that the join should be based on the same fields as the relationship set up in the relationships window. But this is not always true and sometimes the join has to be deleted and then set up in the required way for the query.

MS confuse the process by including an option for Join Type in the relationships screen. This should be ignored, in my view.
You only specify Join type in queries. Join types are critical in terms of how queries behave and so you have to consider the join type for every join in a query irrespective of any relationships you set up.

Go to the top of the page
 
+
access2009eg
post Mar 12 2012, 05:12 AM
Post #3

UtterAccess Guru
Posts: 860



friends
I have to 2 table and I do relationship in query between 2 table
I can’t edit data in a 2 table when in datasheet view in query?
My question why I can’t edit data in a 2 table in query
Is there a property or some thing I can do so I can edit in liked table in query
Go to the top of the page
 
+
arnelgp
post Mar 12 2012, 05:18 AM
Post #4

UtterAccess Ruler
Posts: 1,090



The primary key (PK) of one table should be related to the foreign key (FK) of the other table
Go to the top of the page
 
+
access2009eg
post Mar 12 2012, 05:57 AM
Post #5

UtterAccess Guru
Posts: 860



QUOTE (Peter46 @ Mar 11 2012, 11:01 AM) *
You use both of these because they are not the same.

Relationships define rules for how records are stored and maintained in tables. So you should use these to ensure integrity of your data.

In queries you create JOINS not relationships. Joins are used to extract and display related data. They do not affect how data is stored in the database. If you add tables to the query design grid, then Access ASSUMES that the join should be based on the same fields as the relationship set up in the relationships window. But this is not always true and sometimes the join has to be deleted and then set up in the required way for the query.

MS confuse the process by including an option for Join Type in the relationships screen. This should be ignored, in my view.
You only specify Join type in queries. Join types are critical in terms of how queries behave and so you have to consider the join type for every join in a query irrespective of any relationships you set up.



Thank you for your new concept that I learn
Go to the top of the page
 
+

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

Jump To Forum:
 



RSS Go to Top  ·  Lo-Fi Version Time is now: 22nd May 2013 - 08:09 AM