Results 1 to 4 of 4
  1. #1
    4 Star Lounger
    Join Date
    Jul 2006
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I am trying to join two tables but keep getting attached error.

    The tables which l cannot join are company and fleet data and managment vehicles subform table.

    Attached is the database l am using. I don't mind how the two tables are joined as long as l can create records without any problems and then create a query to link which combines the two.

    Any help would be appreciated

  2. #2
    4 Star Lounger
    Join Date
    Jul 2006
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by jj1972 View Post
    I am trying to join two tables but keep getting attached error.

    The tables which l cannot join are company and fleet data and managment vehicles subform table.

    Attached is the database l am using. I don't mind how the two tables are joined as long as l can create records without any problems and then create a query to link which combines the two.

    Any help would be appreciated

  3. #3
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts
    I didn't see any attachments.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  4. #4
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts
    If you are having trouble attaching your file, you need to use the Full Editor in order to do the attachment - in that mode you will see "Help with attaching files" - also be sure to scrub your database so there is no personal or confidential information in the tables, and you should do a compact and repair as well. You may also need to remove unrelated objects to reduce the size.

    Also, the usual issue with joins not working is because they are different data types - check and see that the fields you are using are of the same data type - i.e. both Long, Integer or Text.
    Wendell

Posting Permissions

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