My Assistant
![]() ![]() |
|
|
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? |
|
|
|
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. |
|
|
|
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 |
|
|
|
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
|
|
|
|
Mar 12 2012, 05:57 AM
Post
#5
|
|
|
UtterAccess Guru Posts: 860 |
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 Top · Lo-Fi Version | Time is now: 22nd May 2013 - 08:09 AM |