hey I have a service co

there is client info and notes on the job

one field is materials needed

so I made a view of just the field of materials needed

but now I would like to operate on that

you know, sort it by supply house or group it independant of the job or dependent on the job.

any way to gather up all the entries for this field over many records and then sort them, and then put them back to view in other ways?

it would even be best if we could call from a database of commonly used materials when we made notes on the job

thanks!