Hi - On the Start Rework Activity form we are adding a UD field for the user to enter the DMR # which corresponds to the rework being performed. We would like to provide the user with a list of DMR values based on the Job/Assembly/Operation they select for rework - as there can be more than one. Does anyone have a suggestion on how to make the DMR# a filtered list based on the selection of these multiple fields?
BAQ with a Quick Search
1 Like
Make it a dropdown and populate it using either a baq or an adapter search
I have a BAQCombo which is pulling the DMR #'s but what I am missing is how to use the values entered on the Start Rework Activity form in the Job/Assembly/Operation fields to filter the BAQCombo list returned from the BAQ to only DMR #'s that apply to this specific selection. Can I filter in the BAQ or is there another way?
Figured out how to filter my BAQCombo from within the BAQ. On LaborDtl table I had to use a constant filter value with “Like”.
My query phrase ended up as follows:
select
[DMRHead].[DMRNum] as [DMRHead_DMRNum]
from Erp.LaborDtl as LaborDtl
inner join Erp.DMRHead as DMRHead on
LaborDtl.JobNum = DMRHead.JobNum
and LaborDtl.AssemblySeq = DMRHead.AssemblySeq
and LaborDtl.OprSeq = DMRHead.OprSeq
where (LaborDtl.JobNum = ‘[Like:JobHead.JobNum]’ and LaborDtl.AssemblySeq = [Like:JobAsmbl.AssemblySeq] and LaborDtl.OprSeq = [Like:JobOper.OprSeq])
group by [DMRHead].[DMRNum]
order by DMRHead.DMRNum
The table used in the “Like” is from the Start Rework Activity form > Customization Tools Dialog > Properties of each field required for the filter - screen shot below is for the JobNum field.
1 Like