looking for a control

[Chris Strug]

Hi,

I have a pretty standard database. Table 1 - Orders which has a one to many
relationship with Table 2 - Line Items.

When viewing these what I'd like is a control that allows me to show the
orders and their items rather like a directory list in Windows Explorer. For
example, a window with a list of the Orders. Each order has a little "plus"
next to it. When clicked, it expands to show all the items in the Order.

I realise that there's nothing in there by default but are there any
external controls I could use?

I hope I've made a reasonable job of explaining this!

Any advice is gratefully received.

Thanks

Chris Strug

 

[Kevin3NF]

You are looking for a treeview control, available from the More Controls
button...I confess I have NO idea how to make it work....

 

[Fredg]

Chris,

This is available now if you are using Access 2002 (not sure about Access
2000).

If you have a relationship defined between the 2 tables,
Tools + Relationships
open the Orders form in Datasheet view and there is a + next to each order.
Click on the + and the details will be shown.

 

[Jonathan]

-----Original Message-----
Hi,

I have a pretty standard database. Table 1 - Orders which has a one to many
relationship with Table 2 - Line Items.

When viewing these what I'd like is a control that allows me to show the
orders and their items rather like a directory list in Windows Explorer. For
example, a window with a list of the Orders. Each order has a little "plus"
next to it. When clicked, it expands to show all the items in the Order.

I realise that there's nothing in there by default but are there any
external controls I could use?

I hope I've made a reasonable job of explaining this!

Any advice is gratefully received.

Thanks

Chris Strug

Hi Chris,
an alternative is the treeview control found in the
toolbox extra controls.

luck
Jonathan

 

[Chris Strug]

Cheers guys, the treeview certainly looks like a winner but its going to be
a bitch to use methinks...

Chris.