Hi, I have three questions relating to custom lists I have a list where the first field is team name. In here i have the option to pick a team from the drop down, or type in your own entry. If someone types there own team name can i get this automatically added to the list?When someone selects a predefined team name from the list mentioned above, is it possible to automatically complete some of the fields based on what was entered in the previous occurance of that team name?Another field asks for job names. This can be one job or multiple. Off the back of this list i have a view that shows job names. Can i have my form so that if someone enters multiple job names, in my view of job names it lists them as individual entries and not one long continuous record?

Hi danwood1985, Thank you for your question. I am trying to involve someone familiar with this topic to further look at this issue. Thanks, Lhan Han

That is great. Thank you. If you need any further information or want me to explain what i am trying to achieve better i will be happy to help.

1.I have a list where the first field is team name. In here i have the option to pick a team from the drop down, or type in your own entry. If someone types there own team name can i get this automatically added to the list? The closest out of the box functionality would be in SharePoint 2010's MMS service where it can auto populate the field for you as you type and add it if it does not exist. 2.When someone selects a predefined team name from the list mentioned above, is it possible to automatically complete some of the fields based on what was entered in the previous occurance of that team name? At a high level you will have to do some coding for this. Most likely you will need some custom JavaScript. Or you could create your own list webpart that has this functionality. It seems like a very similar question to this blog: http://sharepoint.stackexchange.com/questions/14335/auto-populating-columns-within-a-list If youre willing to wait for a user to save the form first, then a workflow can run in the background and fill in the rest of the fields. However the key thing is they have to save that form first before the workflow can fire. 3.Another field asks for job names. This can be one job or multiple. Off the back of this list i have a view that shows job names. Can i have my form so that if someone enters multiple job names, in my view of job names it lists them as individual entries and not one long continuous record? This sounds like it can be accomplished by doing a search on that list and making modifications to the results XSLT. In a nutshell, you can do this but it is going to require some coding. Here is a link to the SDK: http://msdn.microsoft.com/en-us/library/ms452873(v=office.12).aspx Regards, Savoeurn Va Microsoft Online Community Support

I think if i can get question 3 working, the other two questions will not require an answer. So going forward to question 3:- I have had a look at the link you provided but not being very good with sharepoint it was a bit to much for me to understand. The custom list and relevant views are all created already. I am using web part views to show the table and connecting the required fields. The problem is that if a team enters more than one job name, for example CT*, PL*, TX*, when it shows in my custom view of this i want it listed as CT* PL* TX* but it shows as one entry currently. I am trying to explain this as fully as i can but if you need more details then please say.

Hi Danwood1985, Based on the requirement you will have to do custom coding for this and create a webpart that incorporates this functionality.Regards, Savoeurn Va Microsoft Online Community Support