SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am using Windows SharePoint Server 2007. In a custom list, if I have two columns. One has a list of Categories, and the second has a list of Products. So in my Categories Column its a Choice with CheckBoxes to allow for multiple selections. Lets take an example the categories are Cars, Trucks, and Motorcycles. In the Product Column it is also a choice and with CheckBoxes that allow multiple selections. For my example I have Mustang, Camaro, F-150, Sierra, Harley, Kawasaki. Is there any way to check whether a selection in the second one had its parent checked, IE I check Camaro, and F-150, is there anyway to check and see if Car, and truck was checked in my first column?

share|improve this question
Are you looking to drive the 2nd list by the selection in the first list, as in a parent-child relationship? – Laurie Aug 5 '11 at 15:37
@Laurie Yes thats exactly what im going for. – atrljoe Aug 5 '11 at 15:56
up vote 0 down vote accepted

I think you can accomplish what you're trying to do with SPCascadeDropdowns in SPServices, if your goal is to enforce the relationships.

If, instead, you just want to check the situation once the user has made their choices, you can do that with some script of your own.

share|improve this answer

If you are using Choice columns, what you need is a lookup to another lookup which is not supported OOB in SharePoint. In SharePoint 2010 you could make use of the new managed metadata column type which supports hierarchical data, but that is not an option in 2007.

share|improve this answer

Your Answer


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.