you might be able to solve this with pipelines.
1. You could create a 'groups' table
2. When someone adds a line item with a group value typed in -- trigger your pipeline
3. Query groups table for this value (to keep these clean/unique in case people type the same thing commonly)
4. If the group doesn't already exist, create it then relate it to the line item, if it does exist, relate it to the line item
5. set up your report/search based on the related group field
------------------------------
Charlie Murawski
------------------------------
