Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Infopath Form Dropdown Values Based on Secondary Table

Posted on 2014-02-05
2
Medium Priority
?
498 Views
Last Modified: 2014-02-06
I am trying to create a form that collects employee schedule preferences based on a table of options. The options table has the following fields: TEMPLATEID, TEMPLATE_NM, MON_SCH, TUE_SCH, WED_SCH, THU_SCH, FRI_SCH & LUNCH_LENGTH.

As of right now I am have this tables stored in an access database but I think I will be moving it to a Sharepoint list.

Based on who the employee is I will be filtering the table to display the employee's options. From that list I am wanting to collect their top 4 choices sorted by most desirable choice to least desirable choice.

The table where I want to collect the info has the following fields: ID, EE_ID, EE_AREA, CHOICE_01, CHOICE_02, CHOICE_03, CHOICE_O4.

In each "CHOICE_*" field I am looking to collect the TEMPLATE_ID here are my issues that I am hoping to get assistance with:

First, I would like to make the "CHOICE_*" fields drop downs but I would like for use to see the template name instead of the ID.

Second and most importantly, I want to ensure that the user doesnt select the same TEMPLATE_ID more than once. If you are familiar with Sharepoint a good example of what I would like to do with this one is like when you "Modify List View". Sharepoint lets you pick the order that the fields appear but whenever you pick the same order number it moves whatever field has the same order number and moves it down. Something like that would be great.

Any assistance would be much appreciated.

Thank you
0
Comment
Question by:spaced45
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 28

Accepted Solution

by:
clayfox earned 2000 total points
ID: 39837989
Just do some playing with Dropdowns.

SP lists are the way to go.

you can bind the dropdowns to external lists

then select the last folder and set your display and value separately, that way you have the id in the field but display the name.

I would do cascading dropdowns so that the selected option is omitted from subsequent dropdowns.  Search on infopathdev.com for examples.
0
 
LVL 1

Author Comment

by:spaced45
ID: 39840862
Cascading dropdowns! That did the trick. I was able to find a ton of helpful information on infopathdev.com.

Thank you for your assistance.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Have you ever wanted to restrict the users input in a textbox to numbers, and while doing that make sure that they can't 'cheat' by pasting in non-numeric text? Of course you can do that with code you write yourself but it's tedious and error-prone …
Article by: Martin
Here are a few simple, working, games that you can use as-is or as the basis for your own games. Tic-Tac-Toe This is one of the simplest of all games.   The game allows for a choice of who goes first and keeps track of the number of wins for…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…
Suggested Courses

721 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question