[AccessD] treeview control

Arthur,

    I get it. It would be great if you were in a position to send across a skeleton db with just the tables (including their relationship) having some sample data. I have something in mind that should work.

    My email address:  adtp at airtelmail.in

Best wishes,
A.D. Tejpal
------------

  ----- Original Message ----- 
  From: Arthur Fuller 
  To: Access Developers discussion and problem solving 
  Sent: Friday, October 02, 2009 01:39
  Subject: Re: [AccessD] treeview control


  A.D.

  Your suggestions did not quite hit the point I was attempting to make, which
  was Multiple Children Per Parent, each Child residing in a unique table.
  Consider this example:

  Customers
     Locations
        Machines
     ContactPersons

  In the above sketch, both Locations and ContactPersons are children of
  Customers. I want these on separate nodes within the Customers node. I can
  (and already have) figured out the first part of the problem, i.e.
  Customers, Locations and Machines, but the second part still eludes me. How
  to create the Locations node and the ContactPersons node, both being
  children of the parent node Customers? That's the part I cannot figure out.

  TIA.
  Arthur