Building Summary Report for List User Field
Hi! I recently added a List User field ("Estimator(s)") to my table where the person adding a new Project record can indicate one or more individuals involved in quoting a project. I would like to cr...
Forum Discussion
Thank you, Chayce. That is an interesting solution. I can create an employees table. How would I create the link between that table and the User-List field? I know how to create a table relationship, if needed. Would the "Estimators" field need to feed off the employee table, rather than my User list, or would I need to make the connection between the Estimators Field and the Employee table in my report?
------------------------------
Sherri Large
------------------------------
Since the List-User can contain multiple users you can't establish a direct relationship - hence the idea of the formula queries. In this case you would tag the user or the email of the Employee in their record in this new table, and then use formula queries to do a count of the records in your quoting table where the list-user field contains the employee in question using their user/email.
------------------------------
Chayce Duncan
------------------------------