Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2008
    Posts
    3

    Unanswered: How can we set relationship through query?

    I want to set relationship between tables through query.
    Can it possible?
    if yes then how?
    Please help.

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    You do mean create a relationship not a join - correct? Using Data DEFINITION Language?

    I can't remember the syntax but these cover every bit of Access DDL you will ever need (and more):
    http://msdn.microsoft.com/en-us/library/aa140011.aspx
    http://msdn.microsoft.com/en-us/library/aa140015.aspx
    http://msdn.microsoft.com/en-us/library/aa139977.aspx
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    If it's a join - you simply drag the field from 1 table to the joining field in the other table in the query designer. If it's a relationship, see Pootle's post above.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •