Results 1 to 2 of 2
  1. #1
    Ruegen's Avatar
    Ruegen is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2013
    Location
    Australia
    Posts
    1,496

    Many to Many junctions in queries - is there a better way

    I found that when working with junction tables in queries, when you are trying to get queries across a junction and more than three tables I run into a problem where the data becomes read only.

    I found using only the primary keys in the junction as the primary keys for the corresponding tables works fine and the data is still editable in the query however once it starts getting longer it becomes readable. I also get duplicate results sometimes (I'm putting in something wrong obviously).

    Is there a better way of handling this when creating queries stretched over more than 3 tables?

    I've found that to even show the results I've had to make a query of tables, then put that query into the query and it gets the results I want but then makes that query locked...



    The duplicates I have yet to figure out why it is doing that, I suspect I have doubled up an id somewhere..

  2. #2
    Ruegen's Avatar
    Ruegen is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2013
    Location
    Australia
    Posts
    1,496
    Click image for larger version. 

Name:	Screen Shot 2013-08-21 at 11.07.46 PM.png 
Views:	9 
Size:	74.3 KB 
ID:	13518
    Here is an example, right up until I add another juntion table (to ShowsID that goes to a table called "tblJncPerformers2Shows") everything is editable. It's not read only. However - I add that second junction and it is read only. There are no queries within queries - these are all tables in the image.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Need help with a few queries
    By nzlotrfan in forum Queries
    Replies: 4
    Last Post: 05-15-2013, 03:42 AM
  2. I'm not sure how to use queries
    By xibalba in forum Queries
    Replies: 1
    Last Post: 11-09-2012, 01:38 PM
  3. Value from 2 queries
    By kwooten in forum Reports
    Replies: 1
    Last Post: 10-19-2011, 01:23 PM
  4. Need Help with Queries
    By mulefeathers in forum Queries
    Replies: 2
    Last Post: 05-24-2010, 11:37 AM
  5. need help with queries
    By gromit95 in forum Queries
    Replies: 1
    Last Post: 02-06-2009, 06:50 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums