Results 1 to 8 of 8
  1. #1
    Rafegh is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Jul 2014
    Posts
    13

    How to Create Nested Tables using Access?

    Dear all,
    Hi,


    I’m new to MS Access. I need to create a Database using Access in 2 days. This database should have 4 levels of data:
    1) Different projects
    2) Different sections for each project
    3) Different layers for each section
    4) Different datapoints for each layer
    I think I should create nested tables, but the number of tables in each level is calculated from the data given in the previous level. Is there any way to create custom number of similar tables using MS Access?

  2. #2
    azhar2006's Avatar
    azhar2006 is offline Expert
    Windows 7 32bit Access 2007
    Join Date
    Mar 2012
    Posts
    528

  3. #3
    orange's Avatar
    orange is online now Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    What is a nested Table?
    I need to create a Database using Access in 2 days.
    Is this a school project?
    I think you should review this link and learn some basics of database design. This link deals with Normalization.

    I have identified a set of videos that you may find interesting.
    See post #6 HERE

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Sorry, that doesn't make sense to me. What do you mean by the 'number of tables in each level is calculated from the data given in the previous level'. This is not the way to design a db.
    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.

  5. #5
    orange's Avatar
    orange is online now Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716

  6. #6
    Rafegh is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Jul 2014
    Posts
    13
    Thank you for your answers. I have studied a lot about my issue, I have came to a point. For the work that I need to do, I must write an "After Insert" DataMacro. In the actions part of this macro I should select create record option. With this way I could create records for each section in the second table as I enter the "number of sections" field in the first table. Now my problem is that is it possible to create multiple records with different value for one field in the second table using this DataMacro?

  7. #7
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    My inclination is to say no, not with DataMacro. Sounds like need VBA looping structure. I have explored looping code in macros and not easy.

    Are you using forms for data entry/edit?
    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.

  8. #8
    orange's Avatar
    orange is online now Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    For the work that I need to do, I must write an "After Insert" DataMacro
    Really. I agree with June.
    But, I don't think you have given any business rationale re WHAT you are trying to do. Can you give some of the requirements/specifications to see if readers respond with what other options might exist?

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

Similar Threads

  1. Access Tables Create
    By kris9 in forum Access
    Replies: 8
    Last Post: 06-05-2013, 12:43 AM
  2. Replies: 3
    Last Post: 05-15-2013, 07:59 AM
  3. Replies: 3
    Last Post: 03-06-2013, 02:33 PM
  4. Replies: 7
    Last Post: 01-28-2011, 11:15 AM
  5. Replies: 0
    Last Post: 06-29-2010, 12:04 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