Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I have a column named Origination and a column named Sub organization.

When the user choose choice A in organization I need specific choices to pop up for Sub Organization.
When the user chooses Choice B in organization I need different choices to pop up in Sub organization.

Is this possible?

share|improve this question

1 Answer 1

up vote 1 down vote accepted

You might be looking for Cascading Lookup.

There are several of these, like the one on CodePlex, and Mark D have made support for it in his SPServices (SPCascadeDropdowns).

Update:
If you want a very quick and dirty solution you could do this:
By using SPFieldChoice and prefixing the values with previous values like this:

  • Choice Country
    • Norway
    • Sweden
    • Denmark
  • Choice City
    • Norway - Oslo
    • Norway - Ålesund
    • Sweden - Stockholm

You can use jQuery to filter them like this:

var $fields = $('.ms-formbody').filter(function() {
  return $(this).html().match(/spfieldchoice/i);
});
var $s = $fields.last().find('select');
  $s.find('option').each(function() {
  var $o = $(this);
  $o.text($o.text().replace(/.* - /, ''));
});
var $c = $s.find('option').clone();
$fields.first().find('select').change(function() {
  var val = $(this).val();
  $s.empty().append($c);
  $s.find('option').filter(function() {
    return $(this).val().indexOf(val) < 0;
  }).remove();
}).change();​
share|improve this answer
    
My issue becomes that I do not have access to SharePoint Designer or InfoPath. I really just have the basics to use. –  Pureholland Sep 18 '12 at 15:37
    
You could find one that is sandboxed solution, in that case you could just upload it. To be honest we have such solution at work, a sandboxed solution for cascading fields that use the "RelatedField" property for mapping. But I'm afraid it's closed source :( –  eirikb Sep 18 '12 at 15:43

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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