Hi
I am having issues filtering my BAQ combo box.
so I have added a field to the customer table which stores tilde separated VendorID’s this is called DistList _c which is filled in via a selected List on the customer menu.
I have created a BAQ which gets DistList_c and separates each VendorID into separate rows which is then added to a combo box on the Sales Order entry form.
This combo box works but shows everything from the Query so when I try to filter i,t it either still shows everything or nothing.
here is my query
here is the combo box with the BAQ
and here is the filter that I have used
im sort of wondering while writing this if I should be calling erp BAQ from rest services, adding that to a view and using the view to fill in the combo box.
cheers for any help