On the DMR Processing page I’ve added a read only text box. I have a BAQ has a PONum parameter that I want to pass the DMRHead.PONum too and have the text box populate with the BAQ data.
The baq works when you pass in a PONum. But it’s not populating my text box. Any help would be much appreciated.
select
[DMRHead].[DMRNum] as [DMRHead_DMRNum],
(Cast( PODetail.PONUM as varchar) + '-' + CAST(PODetail.POLine as varchar) + '-' + CAST(RcvDtl.PORelNum as varchar)) as [Calculated_PoLineRel]
from Erp.DMRHead as DMRHead
left outer join Erp.PODetail as PODetail on
DMRHead.Company = PODetail.Company
and DMRHead.PONum = PODetail.PONUM
and ( PODetail.RcvInspectionReq = 1 )
left outer join Erp.RcvDtl as RcvDtl on
PODetail.Company = RcvDtl.Company
and PODetail.PONUM = RcvDtl.PONum
and PODetail.POLine = RcvDtl.POLine
where (DMRHead.PONum = @PONum)
group by [DMRHead].[DMRNum],
(Cast( PODetail.PONUM as varchar) + '-' + CAST(PODetail.POLine as varchar) + '-' + CAST(RcvDtl.PORelNum as varchar))
I set up an unblur event on the text box.
and I’m binding it to the calculated field in my baq.
