Treeview and selections.

  • Thread starter Thread starter Sander
  • Start date Start date
S

Sander

Hi,

I want to use a treeview in my form to give a certain
customer mutiple criteria. I want to use more then 1 table
in my treeview and i must be able to select mutiple
values. Then i guess i have to use a button to transmit
the selected values to a certain field in the customer
table.

Does anyone know how to do this or does anyone has a
working example how to do this.

Help would be very appreciated.

Sander.
 
I have been using the TreeView control successfully for a
long time. However, the TreeView is based on a set of
tables that have a heiarchical relationship just like the
Windows Explorer you use in Windows. In fact Windows
Explorer is a TreeView Control with a ListView Control
associated with it. It is important to have your source
tables for the TreeView in a heiarchical relationship for
it to provide the results you want. Ken Getz
book "Access 2000 Developer's Handbook" published by
SYBEX has a good explanation of the TreeView control with
Examples. TreeView control is an ActiveX type control
and there is a good explanation in the Access help file.
I strongly suggest you invest in Ken Getz book
(discounted at Amazon.com).
For me to help you more I will need more details about
your tables and exactly what your objective is.

Cheers,
Henry
 
Hi Henry,
I am creating a database Customers and their
contactpersons.

Now that's not a very big issue. I can also make a couple
of tables which I can fill with certain criteria and make
a combobox for each table wich shows the entered fields.

This is handy if you do not have more than three tables to
link to the customer for his selection criteria.(used in a
query for mailings)

But now I would like to use 9 tables filled with criteria.
for example:
Huurder:
Balletscholen
Amateurs
Educatie:
CKV-docenten
Overige docenten
Bespelers:
Gezelschappen
Impresariaten
Relatie:
VIP
Techniek
etc. etc.

This is also how my treeview must look like. And then I
must be able to select in one customer:
Balletscholen, Amateurs, CKV-docenten, Gezelschappen and
transfer them to the record of the customer and so the
customer now has mutiple selection criteria to be used in
a mailing.

I hope you understand the picture and you have some kind
of solution for me. I tried the Help of Access but that
doesn't help me. I tried the knowledge base and know I am
trying the newsgroup.

Regards,

Sander.
 
Back
Top