Link tables

[Ashley]

Hi,

I have Order and Order Details tables linked.
When I open the Order table, I would like to see the collapse/expanse sign
to show Order Details under each Order record. How do I add collapse/expanse
sign to my Order table?

Thanks

 

[Jackie L]

Ashley,

Sounds like you need to start with a query where you have both tables
linked, then create a form based on your query. The form header can have the
Order table info and the detail section would be the OrderDetail fields. You
can also use a form and a subform for this.

You cannot do this with just tables.

 

[John W. Vinson]

Hi,

I have Order and Order Details tables linked.
When I open the Order table, I would like to see the collapse/expanse sign
to show Order Details under each Order record. How do I add collapse/expanse
sign to my Order table?

Thanks

Well... my advice would be Don't. Subdatasheets are a terrible drag on
performance of your database, and in any case you should not be using Tables
to interact with data in the first place; the function of Tables is to store
data, and you should use a Form with a Subform to interact with the data.

That said... if you want the bad performance, limited features, and bad design
of the subdatasheet... open the Order table in design view. Select View...
Properties from the menu; change the Subdatasheet Name property from [None] to
[Order Details].