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

  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  

  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...

  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...

  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...