How do I create "subs" in a table (like in Northwind)

[Jennifer]

When I view the tables in Northwind there are some kind of
subtables in there... for example, in the Customer table
you can click the "+" next to the Customer ID and see
their orders. How do you do that? It's probably basic
but I just can't figure it out.

Thanks!

 

[Duane Hookom]

The question is "why would you want to do that?"
You can change this table property in design view.

 

[Allen Browne]

1. Open your table in design view.

2. Open the Properties box.

3. Set the Subdatasheet Name property to [Auto].

You may also want to know that this can slow down the loading of your forms,
because Access has to load all the subdata as well. As a result (and because
subdatasheets don't have the events that forms do), most of us turn this
off.

 

[Jennifer]

-----Original Message-----
1. Open your table in design view.

2. Open the Properties box.

3. Set the Subdatasheet Name property to [Auto].

You may also want to know that this can slow down the loading of your forms,
because Access has to load all the subdata as well. As a result (and because
subdatasheets don't have the events that forms do), most of us turn this
off.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

When I view the tables in Northwind there are some kind of
subtables in there... for example, in the Customer table
you can click the "+" next to the Customer ID and see
their orders. How do you do that? It's probably basic
but I just can't figure it out.

Thanks!

.

 

[Jennifer]

-----Original Message-----
1. Open your table in design view.

2. Open the Properties box.

3. Set the Subdatasheet Name property to [Auto].

You may also want to know that this can slow down the loading of your forms,
because Access has to load all the subdata as well. As a result (and because
subdatasheets don't have the events that forms do), most of us turn this
off.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

When I view the tables in Northwind there are some kind of
subtables in there... for example, in the Customer table
you can click the "+" next to the Customer ID and see
their orders. How do you do that? It's probably basic
but I just can't figure it out.

Thanks!

.

 

[Jennifer]

Thanks for the advice - our network is slow enough, I
don't need this slowing my dbase down Thanks!

-----Original Message-----
1. Open your table in design view.

2. Open the Properties box.

3. Set the Subdatasheet Name property to [Auto].

You may also want to know that this can slow down the loading of your forms,
because Access has to load all the subdata as well. As a result (and because
subdatasheets don't have the events that forms do), most of us turn this
off.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

When I view the tables in Northwind there are some kind of
subtables in there... for example, in the Customer table
you can click the "+" next to the Customer ID and see
their orders. How do you do that? It's probably basic
but I just can't figure it out.

Thanks!

.