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 |
#1
|
|||
|
|||
Where should relationships be created?
I am trying to clarify where the prefered location is for relationships. I
am working as a contract employee to "cleanup" a database created by someone else. All relationships have been created using queries. Are queries the correct place the create realtionships. Basically no relationships between the tables were created and most of the tables have not had a primary key set. I have always thought and perhaps I am incorrect the the proper place to create relationships is between tables and to use query relationships as additional no primary relationship. Is this incorrect? Thank you in advance for your assistance. |
#2
|
|||
|
|||
Where should relationships be created?
See post by ThomasAJ and responses 10/24/2009
Where to define Relationships - FE or BE? -- Build a little, test a little. "lpierce819" wrote: I am trying to clarify where the prefered location is for relationships. I am working as a contract employee to "cleanup" a database created by someone else. All relationships have been created using queries. Are queries the correct place the create realtionships. Basically no relationships between the tables were created and most of the tables have not had a primary key set. I have always thought and perhaps I am incorrect the the proper place to create relationships is between tables and to use query relationships as additional no primary relationship. Is this incorrect? Thank you in advance for your assistance. |
#3
|
|||
|
|||
Where should relationships be created?
Karl,
I think the OP was asking about table level vs. queries, not FE vs. BE. - - - - Dear, Lpierce, I don't know the best/official way, but I create them at the table level and refine/specialize/modify them at the query level as needed. |
#4
|
|||
|
|||
Where should relationships be created?
lpierce819,
I have never used Queries to create relationships as the Queries include tables. I have only used Tables when creating relationships. Now, that being said, there might be legitimate reasons to use queries, I just can't hink of one. I should also note that tables can have a PK (Primary Key) and/or FK (foreign Key) but do not have to have both. Personally, I like all my tables to have a PK whether I use it or not is another long story. If you need help determining which tables should have what type of Key, you can post table names with what you think may be the FK and/or PK and we can further assist. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "lpierce819" wrote in message ... I am trying to clarify where the prefered location is for relationships. I am working as a contract employee to "cleanup" a database created by someone else. All relationships have been created using queries. Are queries the correct place the create realtionships. Basically no relationships between the tables were created and most of the tables have not had a primary key set. I have always thought and perhaps I am incorrect the the proper place to create relationships is between tables and to use query relationships as additional no primary relationship. Is this incorrect? Thank you in advance for your assistance. |
#5
|
|||
|
|||
Where should relationships be created?
Gina,
Did you mean that: - you never use a query as one side of a relationship? or - you never create relationships in the query design screen? Thanx Fred |
#6
|
|||
|
|||
Where should relationships be created?
Fred,
After REreading my reply I see where you came up with your question. I meant I have never used a query as one side of a relationship. However, that does not mean there may not be a legitimate reason for doing so, just that I have never done it. However your second question... You cannot *create* a relationship in the Query Design Grid. You can use preexisting relationships *created* in the Relationship Diagram Window. OR did I misunderstand your second question? -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Fred" wrote in message ... Gina, Did you mean that: - you never use a query as one side of a relationship? or - you never create relationships in the query design screen? Thanx Fred |
#7
|
|||
|
|||
Where should relationships be created?
On Tue, 03 Nov 2009 06:53:01 -0800, Fred wrote:
Gina, Did you mean that: - you never use a query as one side of a relationship? or - you never create relationships in the query design screen? The lines between tables and queries that you see in the query designer are not "relationships". They are "joins". -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com |
#8
|
|||
|
|||
Where should relationships be created?
Rick,
That we know... I think Fred was referencing the way I answered a question and making me take note that it was probably not as clear as it could/should have been. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Rick Brandt" wrote in message ... On Tue, 03 Nov 2009 06:53:01 -0800, Fred wrote: Gina, Did you mean that: - you never use a query as one side of a relationship? or - you never create relationships in the query design screen? The lines between tables and queries that you see in the query designer are not "relationships". They are "joins". -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com |
#9
|
|||
|
|||
Where should relationships be created?
Yeah, but it is because Fred is trying to learn from your expertise, not
commenting on the the thoroughness of your answer. And would still like to know the answer. :-) Thanks fred |
#10
|
|||
|
|||
Where should relationships be created?
Fred,
I am soooo sorry, was my reply still not clear? Please explain what part is not clear OR maybe my reply never made it thru? REPOST Fred, After REreading my reply I see where you came up with your question. I meant I have never used a query as one side of a relationship. However, that does not mean there may not be a legitimate reason for doing so, just that I have never done it. However your second question... You cannot *create* a relationship in the Query Design Grid. You can use preexisting relationships *created* in the Relationship Diagram Window. OR did I misunderstand your second question? -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Fred" wrote in message ... Yeah, but it is because Fred is trying to learn from your expertise, not commenting on the the thoroughness of your answer. And would still like to know the answer. :-) Thanks fred |
Thread Tools | |
Display Modes | |
|
|