P
(PeteCresswell)
I've got a DB where a single bond can have many issuers.
So far, so good.... just have a "Single" form for the bond info
and a "Continuous" form that shows info for each issuer.
The trouble begins with an issuer having a "Country" property -
such that a single issuer can have many countries. Ditto
"Dealers".
I guess I could have a continuous subform or a listbox that shows
all the issuers - and then refresh another area on the parent
form to show the detail for the currently-selected issuer.
But what I'd really like to do is let the user see the info for
all the issuers at a single glance.
Only thing I can think of is some implementation of the TreeView
control - where the Issuer's name appears at the top of a
hierarchy, and the various properties appear in sub nodes below
it.
Anybody else been here? Is there another solution to show
something like:
----------------------------------
Bond
Name=ABC
Issuers
Name=Smith
Countries
United States
Great Britain
South Africa
Name=Jones
Countries
Mexico
Bermuda
Name=Anderson
Countries
Canada
Dealers
Name=JPMorgan
Name=Stanley
Name=GeroldBank
So far, so good.... just have a "Single" form for the bond info
and a "Continuous" form that shows info for each issuer.
The trouble begins with an issuer having a "Country" property -
such that a single issuer can have many countries. Ditto
"Dealers".
I guess I could have a continuous subform or a listbox that shows
all the issuers - and then refresh another area on the parent
form to show the detail for the currently-selected issuer.
But what I'd really like to do is let the user see the info for
all the issuers at a single glance.
Only thing I can think of is some implementation of the TreeView
control - where the Issuer's name appears at the top of a
hierarchy, and the various properties appear in sub nodes below
it.
Anybody else been here? Is there another solution to show
something like:
----------------------------------
Bond
Name=ABC
Issuers
Name=Smith
Countries
United States
Great Britain
South Africa
Name=Jones
Countries
Mexico
Bermuda
Name=Anderson
Countries
Canada
Dealers
Name=JPMorgan
Name=Stanley
Name=GeroldBank