I'm using SP2010 unfortunately without SP Designer and only used InfoPath once.

I have 2 lists:

  • List A - Is a list of 'Event Codes' with a 'status' column displaying Active, Used or Reserved status for each Event Code.

  • List B - Has a look up column displaying an Event Code from List A.

When adding a new item to List B and selecting an event code from the drop down box, I want to view all event codes and their allocated status next to each event code.

In effect having data from two columns displaying in the drop down menu.


  • Do you want values to look like this in your dropdown of list B: Option1: Code1 Active / Option2: Code2 USed / Option3: Code3 Reserved / ??
    – Gaurravs
    Oct 8, 2015 at 4:39
  • Thanks for your reply. I would like the drop down menu to display each code, and their individual statuses. EG: Code1 - Used Code2 - Used Code3 - Active Code4 - Reserved
    – Blake
    Oct 8, 2015 at 21:52
  • sorry I didnt understood your last comment
    – Gaurravs
    Oct 9, 2015 at 6:28

1 Answer 1

  1. Create calculated column in SharePoint list.

    =CONCATENATE(Code," ",Status)
  2. Update secondary data source with adding new calculated column in InfoPath form.

  3. Set calculated column as data source in dropdown property in InfoPath form.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.