Hello all,
I am a newbie to InfoPath and am working on a visual demonstration of
capabilities of this program and SharePoint.  One of the areas I am
working on now is having a list in SP that is used as a dropdown list
in an InfoPath form.  That was easy but I want to go to another level.
   Background: Using the OFFSET command and named ranges I have used
Excel to create dropdowns based on a prior selection.  For example, if
I select LEGAL Department, I will only see the divisions in the LEGAL
Department not everything in the entire company.  Then I can select
only the offices in a specific division in the LEGAL Department.  Does
this make sense?  This was done for a purchase requisition form.
    I would like to do the same with InfoPath, having four selections
(or levels): Department, Office, Division, and Branch.  Each selection
would limit the choices available based on the prior entry.  Any ideas
how to best set this up as a list in SharePoint, or the function
syntax necessary, or even a link to a site addressing this topic
appreciated.