I have a list (SP2010) which is used to record payments from different offices. I have created a WorkFlow that emails the accounts team with the details. I have also created a new custom form for the list.
The issue I face is that we have 10 regions each with 10 live offices. The offices come and go so the list is constantly updating. At the moment the end user, when filling in the form, chooses the region from a drop down list and then in the next field manually types in the office name in a simple text field. The reason they manually type the office name is because I do not want to have to keep updating this 'Office' field every time a new office is commissioned or decommissioned.
An issue with this approach is that one end user may call the office London with a capitol L and another user may call it london with a lower case l, another user may call it London, UK. Basically I have no consistency so ultimately this causes more dilemmas down the road in reporting.
Now each time a new office is commissioned a site collection is created but I do not have the skills to develop this list field to look at site collections and populate this list field with the site collection title property!
What options do I have available to me? I am running SharePoint 2010 Enterprise and using SharePoint Designer 2010, I have very basic developing skills.