Combine Calculated felds into one row via BAQ's

[gpayne (Greg Payne)]

@Ricky90 I think this is covered in this post. I would probably just make it an updatable baq and do a foreach in getlist post processing to combine them, but I am lazy.

BAQ: Calculated Field Concatenate Rows to single field

Is there a function/query that will allow multiple returned rows to be combined into a single field? I’m looking thru the PO Tables and finding all PO numbers for a specific job. The job may have 3 POs. PO Number : Job Number 70001 : 00245 70010 : 00245 70008 : 00245 I want to combine/concatenate these to be something like Job Number : PO Numbers 00245 : 70001,70010,70008