I am looking for a way to use sharepoint to automatically fill inn information from a sharepoint list into various forms. Typically network useragreements for different networks, employment contracts etc.
When new employees arrive we have to fill in 10 different forms using the same information, such as last name, first name, DOB, employee number, phone number etc.
I am looking for a way to put all that information in a list in sharepoint and be able auto generate forms with all the fields automatically filled out in the form using the data in the sharepoint list.
I've tried to use infopath and i created a data connection to the sharepoint list. I am able to display fields individually using sharepoint list data and drop down buttons, but im not able to link them up to change value when the value of other fields are changed. When i select "John Johnson" in the first field, i want the rest of the fields to be populated with data from the same line in the sharepoint list as John Johnson.
Intention is to be able to print off forms ready for signatures without handjamming everything. I dont want to manipulate sharepoint list data in the form so i need a read only solution.
Any advice on the matter i greatly appreciated!