I must have a mental block on how this works. I have found several threads related to this subject, but I cannot seem to connect the dots. I have a working classic client customization with a BAQ combo that requires a parameter to be passed. The BAQ is
select
[CustCnt].[Name] as [CustCnt_Name],
[CustCnt].[ConNum] as [CustCnt_ConNum]
from Erp.Customer as Customer
inner join Erp.CustCnt as CustCnt on
Customer.Company = CustCnt.Company
and Customer.CustNum = CustCnt.CustNum
where (Customer.CustNum = [EpiBinding:QuoteHed.CustNum])
The classic BAQ Combo looks like this
I believe I need to use the Filter and Filter Params fields. I’ve tried several different combinations, but I would think this would work.
Running this, I see a server side error of:
Query Id: FCII01-Quote-Contacts. Invalid column name EpiBinding:QuoteHed.CustNum
If I remove the EpiBinding where clause, the BAQ runs and returns a bazillion rows so I know the basic connection is there.
What am I missing?