I have 30 subsites (one for each customer) in Sharepoint, they all have the same forms and work pretty much the same. One of my forms is a Customer Service Record which is just basically a way for techs to record work done at a customers site. What I would like to do is add a "Travel" checkbox to this form and publish the new form to all the sites. Each customer is a certain distance, in miles, from the office. How would I do this: tech creates new CSR in a customers SP site and had to drive there so he would put a check in the "travel" checkbox, then behind the scenes once form is submitted the round trip mileage would be automatically entered into another form with date, customer name and mileage amount so that once a month he can submit it for reimbursment. The tricky thing is that each customer is going to be different mileage. I am sure I am going to have to change the form 30 times and publish it as each CSR form will have different mileage info.
Any help/Ideas?