Results 1 to 3 of 3

Thread: Join table/queries to map features from shp

  1. #1
    Member
    Join Date
    2005-01
    Posts
    4
    Login to Give a bone
    0

    Default Join table/queries to map features from shp

    Hey,

    I have connected an Access database to my project and joined a table to features from a shapefile. No problem there.
    When joining a table there is a dropdownbox with all the tables you can choose from. The dropdownbox also shows all queries in the connected database. Although i can select those aswell they do not properly join. An error message indicates you need a primary key to make the join. As far as i know it isn't possible to add a primary key to a query.
    I would like to use these queries to make a join because that way i can prepare and predefine joins in the database.
    Another reason is because the key in the primary table matches a combination of columns in the database table. That is easily combined in a query.
    I don't think that was the best choice for a primary key but the database has some history.

    Is there a way to use queries from the database to make a join?

    Regards,
    Tim

  2. #2
    Geospatial Moderator Jmurphy's Avatar
    Join Date
    2000-11
    Location
    TN/KY Area
    Posts
    1,640
    Login to Give a bone
    0

    Default Re: Join table/queries to map features from shp

    Check your thread on the Autodesk forum there are a few replies.
    J. Murphy
    AKA
    Murph
    The former AutoCAD MAP3D Power User

  3. #3
    Member
    Join Date
    2005-01
    Posts
    4
    Login to Give a bone
    0

    Default Re: Join table/queries to map features from shp

    Thanks, I didn't think it got posted since i kept getting errors on submitting the post.

Similar Threads

  1. Add Missing Features in Assembly level Features
    By Wish List System in forum Inventor Wish List
    Replies: 0
    Last Post: 2012-10-12, 09:03 PM
  2. cant check in features - features remain in edit set
    By glenn22 in forum AutoCAD Map 3D - General
    Replies: 3
    Last Post: 2009-10-16, 05:18 PM
  3. Table Queries
    By Dave F. in forum VBA/COM Interop
    Replies: 6
    Last Post: 2007-11-15, 06:13 PM
  4. demystifying AutoCAD's table/formatting features??
    By curtisj in forum CAD Management - General
    Replies: 3
    Last Post: 2007-11-12, 09:51 PM

Posting Permissions

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