Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku Search messages from lefora.com (free forums) Lefora
My account: Login | Sign Up
Loading... 

Thread: Where should relationships be created? in microsoft.public.access.tablesdbdesign

Started 1 month, 1 week ago by lpierce819
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 ...
Site: www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.access.tablesdbdesign  www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.access.tablesdbdesign - site profile
Forum: microsoft.public.access.tablesdbdesign  microsoft.public.access.tablesdbdesign - forum profile
Total authors: 4 authors
Total thread posts: 5 posts
Thread activity: no new posts during last week
Domain info for: microsoft.com

Other posts in this thread:

KARL DEWEY replied 1 month, 1 week ago
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...

Fred replied 1 month, 1 week ago
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....

Gina Whipp replied 1 month, 1 week ago
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 ...

Fred replied 1 month ago
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

 

Top contributing authors

Name
Posts
Fred
2
user's latest post:
Where should relationships be...
Published (2009-11-03 06:52:00)
  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  
lpierce819
1
user's latest post:
Where should relationships be...
Published (2009-11-02 08:30:00)
  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...
KARL DEWEY
1
user's latest post:
Where should relationships be...
Published (2009-11-02 08:43:00)
  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...
Gina Whipp
1
user's latest post:
Where should relationships be...
Published (2009-11-02 15:13:00)
  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...

Related threads on "www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.access.tablesdbdesign":

Related threads on other sites:

Thread profile page for "Where should relationships be created? in microsoft.public.access.tablesdbdesign" on http://www.microsoft.com/communities/newsgroups.... This report page is a snippet summary view from a single thread "Where should relationships be created? in microsoft.public.access.tablesdbdesign", located on the Message Board at http://www.microsoft.com/communities/newsgroups.... This thread profile page shows the thread statistics for: Total Authors, Total Thread Posts, and Thread Activity