Jun 29, 2011 at 2:14 PM
Edited Jun 29, 2011 at 2:18 PM
my situation is pretty simple, we just have two drop down menus (choices) named State/Country and PoP with more than 50 options each (unfortunately since we have so many options Fill-in Choice is not an option :( ),
The solution i'm looking for is when the user selects PoP, the State/Country is filled in automatically. The relationship is mostly 1 PoP to 1 State/Country, with an exception to maybe a couple 1 PoP to 4 State/Country relationships also. I would like
the first and only available State/Country to be filled in automatically if that's the case.
I've done this using marc's most recent version of SPServices and SPCascadeDropdowns function which also has the new
If set to true, the child dropdown will be converted to s "simple" dropdown if it is a "complex" dropdown on page load. See
for details on how this works. The default value is false.
If set to true and there is only a single child option, select it. The default value is false.
functions (kudos to marc) It really works well,
I was just looking for an option without having to create new lookup columns ( since close to your situation, we already have a huge list), maybe reading the list directly from the JS etc....)
I was about to just give up and let my supervisor know I couldn't find that option and maybe just create the lookup columns and run a workflow to transfer the column data somehow but if you can give some help / guidance as to how to do this it'll be most
greatly appreciated :)
Thanks for your time Dan,