Results 1 to 2 of 2
  1. #1
    nickjon is offline Novice
    Windows XP Access 2007
    Join Date
    Aug 2011
    Posts
    1

    Subdatasheet in a table without a primary key

    Hi!



    I need to create 6 subdatasheets (subordinated) in a table. Because the subdatasheets have a lot of duplicate entries, I can't use a primary key in them and hence after creating one subdatasheet can't have another subdatasheet under it. I wonder if there is any way to get around this.

    In attachment as an example I have created one main table and two subdatasheets. The subdatasheets can have multiple duplicate entries. In the "Main Table" if you go to column ID and row 74, you can see that it makes references to the subdatasheet. But here I couldn't have one more subdatasheet under this subdatasheet because Access didn't allow me to set a primary key in it.
    Any help would be very much appreciated!
    Nick

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    Don't work directly with tables. Build forms as interface with tables. Form can have subforms and subforms can have subsubforms.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Replies: 18
    Last Post: 07-26-2011, 04:38 AM
  2. Replies: 0
    Last Post: 03-03-2011, 05:17 AM
  3. table relations & primary key
    By mwabbe in forum Access
    Replies: 9
    Last Post: 08-19-2010, 10:09 AM
  4. Problem with subdatasheet
    By bryanno in forum Access
    Replies: 1
    Last Post: 03-13-2010, 08:23 PM
  5. Wierd subdatasheet problem
    By Lynnwood in forum Access
    Replies: 0
    Last Post: 10-30-2009, 08:12 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
  •  
Other Forums: Microsoft Office Forums