Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2014
    Posts
    3

    Unanswered: How to Create Nested Tables using Access?

    Dear all,
    Hi,
    Im 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
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    You only need four tables.

    Look up the concept of Foreign Keys to understand why only four tables are needed.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  3. #3
    Join Date
    Jun 2014
    Posts
    42
    Provided Answers: 1
    2 days? :O

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Quote Originally Posted by pdevito3 View Post
    2 days? :O
    The assignment is due tomorrow.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

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