I have list that I need 2 columns (Choice) to pull up different fields

Question

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?

Answer 1

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();​