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

  • Thread starter Thread starter Jennifer
  • Start date Start date
J

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!
 
The question is "why would you want to do that?"
You can change this table property in design view.
 
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.
 
-----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!
Click to expand...


.
Click to expand...
 
-----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!
Click to expand...


.
Click to expand...
 
Thanks for the advice - our network is slow enough, I
don't need this slowing my dbase down :P 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!
Click to expand...


.
Click to expand...
 
Back
Top