Viewing Limited dropdown lists

  • Thread starter bluegrassstateworker
  • Start date
B

bluegrassstateworker

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Office 365 Calender 0
Quick Parts / SharePoint Library Update 0
How to Submit rows of a repeating table to a SharePoint list 1
Get field-value from dropdown-menu value 0
Convert library to list 0
error: The form cannot be submitted because of an error. 0
Sharepoint not capturing staff name when automation runs 0
dynamically change datasource for dropdown in infopath forms 2

Top