Solved

Access Parent Child Table

Posted on 2014-02-17
5
1,382 Views
Last Modified: 2014-03-21
Hi

I am new to development and wondering how a table would be created with a tree.  I have seen an example but not sure what properties should be set..  Ie Expand (+) a child table in a way of a drilldown.  I am looking for a basic example

Eg Table !
Name,Address CarModel

Eg Table 2 (Drill down from above table)
CarModel, Engine CC, Gears,

Thanks
0
Comment
Question by:yasanthax
5 Comments
 
LVL 24

Expert Comment

by:chaau
ID: 39866450
All you need to do is to create relationship between these tables. Open Database Tools -> Relationships. Select your Table1 and Table2. Then use your mouse to drag CarModel Column from one table to another. This will bring a dialog (similar to one below) where you can specify additional options. FYI, relationship in Access is a feature commonly known as Foreign KeyTable Relationship
0
 
LVL 11

Accepted Solution

by:
Technodweeb earned 150 total points
ID: 39866452
The trick to make this work is to create a lookup from table1 to table2. Then in Table3 you will get the drill down items you seek. See the attached example db file.
Access-Parent-Child-Table.accdb
0
 
LVL 30

Expert Comment

by:hnasr
ID: 39866515
In general:
table1 (idt1, name1, other fields)
table2 (idt1, idt2, name2, other fields)
table3 (idt2, idt3, name3, other fields)
...
If you fill the tables with test data, and open table2, you can drill down to table3.
0
 
LVL 34

Assisted Solution

by:PatHartman
PatHartman earned 50 total points
ID: 39867288
The trick to make this work is to create a lookup from table1 to table2.
Lookups at the table level are a crutch for those who don't know how to create a query.  They will cause nothing but trouble once you learn to use queries and code.  Professional developers advise strongly against using them.  If you want a combo, put it on a form.  If you want to display lookup data in a query, use a query that joins the main table to the lookup table.
0
 

Author Closing Comment

by:yasanthax
ID: 39944782
thanks no I understand it well. Sorry for late response
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now