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 one list with different musical Genres, this list is linked as a lookup to the lists Bands and Records. When I register a new band I set the typical genres played by this band and when registering a new record I register band and genres.

Is there any recommended technique to automatically (and dynamically) read the genres from the Band item and fill the genres list when creating a new record?

I was thinking to create some integration web service that can read genres from bands returning a json and fill the genres list with the help of a javascript. I have the "onchange" functionality in place.

New Band

New Band

New record

New record

Thanks for any help.

share|improve this question
add comment

1 Answer

up vote 1 down vote accepted

If you are within a standard list form by default there is none. However a combination of jQuery, CEWP web parts could help you reach your goal.

See here for an example http://www.sharepointkings.com/2010/09/sharepoint-cascading-drop-downs-using.html and here http://spcd.codeplex.com/

Do not forget there is always the Listdata.svc that could easily be used from within jQUery and CSOM which could enable easy CAML Query filtering of related items, see here http://msdn.microsoft.com/en-us/library/gg701783.aspx

There is always Marc's jQuery library for Web Services, for more advanced tricks http://sympmarc.com/tag/jquery-library-for-sharepoint-web-services/

share|improve this answer
add comment

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.