I too fall into the "noob" category. I've been working on getting my dropdowns to cooperate with little success. I've set mine up similar to a blog I'd seen on 9/30 - it was with Makes and Models of SUV's 9. I used the same column
names so I could duplicate it - just changed the data within the columns.
I've got 2 lists - Makes and Models
Makes = 1 column -- Title
Models = 2 columns -- Make & Model
Available At Duty Station
Available Temp Duty Station
I've got the two jQuery libraries loaded in a document library on the same home site (jQuery.SPServices-0.4.1.min & jQuery-1.3.2.min). -verbatim from the library list.
Here's the code I've added to the NewForm.aspx page via Content Editor Web Part:
I've got my main list (actually a calendar) with two lookup columns: 1) Make - getting info from the Makes list, title column and 2) Model - getting info from the Models list, model column.
My "Make" field on the NewForm is showing the options Available or Unavailable so that is okay (I think).
Problem is that when I select either one, I get the full list of both available and unavailable options (Models list) instead of the related available or unavailable options (its connecting, just not the right way).
I've tried all types of combinations to get them to separate with no success - based on what I've described, do you see any misdirections?
Thank you so much for time and assistance.