First time user & poster here. A friend recommended me to this site for a question I have in relation to populating columns within a list. Hopefully I can explain it properly and someone could point me in the right direction :)
Environment: MOSS 2007
I have done some extensive reading on scripts for cascading drop downs but I am not sure this is the right solution for my situation noted below
Effectively I have 2 lists at the moment. One master list with all the related employer information and a secondary list that will display the data from the main list. The master employer list has almost 5000 entries spread across 4 columns
• empcode • empname • accmgr • emptype
What I would like to do is based off the above list, create a lookup in my secondary list via the empcode when a new item is created. The lookup in theory is fine, but this is the part im stumped at... is it possible to auto populate the 3 remaining fields in the form after employer code has been chosen?
So to re-iterate if its not very clear:
empcode = S32 empname = test accmgr = mrtest emptype = test123
Once I select S32 from the drop down in my secondary list, the following 3 columns are automatically populated on load from the master list.
Would cascading drop downs be sufficient for this example? The reason why I am reluctant to use it I guess is because each employer code is unique, so each employer code (which is close to 5000) has one unique employer name
I thought there may be an easier way to use some form of script to grab the information from the master list to display that information
I hope I have explained this as clear as I can and really could appreciate some feedback if it can be done