Hello-

I have a database with each record being a Purchase order, and a Portal setup to find all the statuses of the line items within that PO from another database with every line open from every Open PO in our system. What I need to figure out is how to export the record so that it will list all of the statuses in that PO which the Portal displays.

The ideal output would be

PO # - Status 1 - Status 2- Status 3- Status 4, etc

also is their a way to filter out repeated statuses in the portals so that it lists each status only once?

thanks!

Create a value list based on the related status field. Then create an unstored calculation text field in the PO of

PONumber & " - " & Substitute( ValueListItems( Get(FileName); "YourValueList" ); ¶; " - " )

and export this field.