I have a dropdown list that populates po’s correctly. But I also want to show the line and release for that PO. I’m guessing it needs to go in the Text field. I am getting the line and release for the PO in the BAQ.
What is the correct syntax to do that?
Would it be something like: ${RcvDtl.PONum}-${RcvDtl.POLine}-${RcvDtl.PORelNum}
Not a direct answer… but try just a comma delimited list.
I haven’t done this with a BAQ combo, but I did it with a UserCode combo:
I “retrieve” both columns I want…
At the bottom of the Advanced Properties, there is a a Columns area
You can set up multiple columns in there:
and get multiple columns to display:
So… for a BAQ combo, I don’t know if you would use a comma delimited list in the TextField? Not sure.
I don’t have a direct answer here - but the work around I’ve used a million times in the past is just make that a calculated field in the BAQ and return that column instead.
Do you need an underscore in that first column: RcvDtl_PONum ?
That worked. I added a calculated field on the BAQ and referenced it.
