Hello,
What I am trying to do is similar to having multiple salespeople on one order but I didn't know how else to title it. I work for a water district and we use a form using one table to keep track of our customer service responses. It is currently setup with only one input field to have the name of the employee responding. Sometimes we have more than one person responding and in the past we just be a space between the two or more names. We would like to be able to have reports by employee name but when we do that it will only list the employees name that is listed first. Is there a way to do a report without changing the form or would it be better to change the form to have more than one responder added to each customer service response? If this doesn't make any sense I apologize and of course will answer any questions I can. Thanks in advance for any assistance.
Billy
What I am trying to do is similar to having multiple salespeople on one order but I didn't know how else to title it. I work for a water district and we use a form using one table to keep track of our customer service responses. It is currently setup with only one input field to have the name of the employee responding. Sometimes we have more than one person responding and in the past we just be a space between the two or more names. We would like to be able to have reports by employee name but when we do that it will only list the employees name that is listed first. Is there a way to do a report without changing the form or would it be better to change the form to have more than one responder added to each customer service response? If this doesn't make any sense I apologize and of course will answer any questions I can. Thanks in advance for any assistance.
Billy
