I have two lists. One is a consulting request list, and the other is one of 9 Solution Request Lists. After the user requests the consultation and the consultation is closed, We will be providing the requester with a Consulting Request Number, and a link to a solution oprdering page. When the requester inputs the Consulting Request number, we want all matching fields to be populated into the solution request list. Can you recommend a method for this? I am trying to avoid coding, but have found no simpole method of doing this within sharepoint. here is what it would do. Please advise.
User enters Consultation number to new list item Solution number to be generated from Consultation Number + backend text ENS200903260001--------------------------------->>>> ENS200303260001-RVPN
Following fields would need to be populated to exact fields in Solution Request List User ID ----------------------------------------------->>>> User ID User Location --------------------------------------->>>> User Location User Department ----------------------------------->>>> User Department User Supervisor ------------------------------------>>>> User ID Business Case -------------------------------------->>>> Business Case Financial Benefit ------------------------------------>>>> Financial Benefit
Please advise. Again, if this can be done in Sharepoint without coding, would be greatly appreciated. Thanks to all for your assistance.
