looking for a control

  • Thread starter Thread starter Chris Strug
  • Start date Start date
C

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
 
You are looking for a treeview control, available from the More Controls
button...I confess I have NO idea how to make it work....:-)
 
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.
 
-----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
Click to expand...
Hi Chris,
an alternative is the treeview control found in the
toolbox extra controls.

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

Chris.
 
Back
Top