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!
VBBRettAsked:
Who is Participating?
 
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
 
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
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.