Nested tables


G

Guest

I notice some of the tables in the Northwind sample database have other
tables "nested" within.
How may I build a table like the sample's?
To illustrate, in the Categories Table, the first column is filled with "+"
which when clicked on, expands and show a new table (whose name is not shown
but it appears to be the "product" tabloe with the "categories" column taken
out.)

Similar, the "product" table itself contains a nested table within itself,
and that appears to be the "order details" table with the "product" column
taken out.

How are these nested tables created?
David
 
Ad

Advertisements

N

Nikos Yannacopoulos

David,

The functionality you describe is called "subdatasheet". To do this, the two
tables need to be joined on some field in the database's relationships; then
Access will default a table as another one's subdatasheet if there exists a
one to many relationship between them, but there may be cases where table A
is the one side of a one to many relationship with table B and with table C;
the table you get in table A's subdatasheet may not be the one you want. In
that case, open table A in design view, go to meny item View > Properties,
and change the Subdatasheet Name property.

HTH,
Nikos
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can Tables Be Nested? 2
Nested Tables - "Not using Parent / Child" 6
Nested table field lookup question 1
Nested Forms 1
Nested sets 3
Nested transaction in 2002 11
Nested combo box 1
Nesting IIF Function 4

Top