• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 728
  • Last Modified:

Building a hierarchical database application with Access; Need help!

I am building a hierarchical database application with Microsoft Access and I am running into some problems.  I'm sure this is the place to ask, but how do I go about building the application in a hierarchical way?  The database only consists of forms, tables and queries.  Thanks!
0
VBBRett
Asked:
VBBRett
  • 2
  • 2
1 Solution
 
Patrick MatthewsCommented:
Hello VBBRett,

That depends on what you mean by "hierarchical" :)

Regards,

Patrick
0
 
peter57rCommented:
Agree - you'll have to explain what you mean.
0
 
VBBRettAuthor Commented:
Hello Matthew.  What I mean by that is having different levels to the database.  First having a higher level on the form and descending with each subform and form.  Does the parent/child relationship take care of that already so that I don't have to worry about all of that?
0
 
Patrick MatthewsCommented:
VBBRett,

In that case, it is pretty straightforward.  Just make sure that the "level n+1" tables always
have a foreign key link back to the "level n" tables.  For the forms, a main/sub form design
makes the most sense.  I've had designs where I have a main form with >=1 subforms, and
then each subform may have its own subforms (and so on) down many levels.

Regards,

Patrick
0
 
VBBRettAuthor Commented:
Thanks Patrick.  That is pretty much what I was looking for in the answer.  Nothing to technical, just straightforward.  I appreciate your answer.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now