I have a UD table, with a Key1 being like the JobHead.JobNum field.
I also have the ShortChar03 like JobOper.OpCode
I am trying to make a dashboard, that when you enter the job number, the baq combo box gets filtered for shortchar03 based on the OpCodes associated with that specific JobOper.
So in my BAQ (ResourceLocationsOnJob) for getting a list of codes based on the Job Number, I have this criteria set:
In the dashboard, I have the baq combo box set as so:
with a tracker query control set for the ShortChar03 on the UD table.
In the BAQ that the dashboard runs off of, I have the ShortChar03 field as a dropdown based on the same query
The drop down does actually filter correctly. However, every time I click off of the drop down baqcombobox, I’m getting a null parameter error. My BAQ’s do not have a parameter set. It also seems to cause the Key field to be flaky, randomly clearing it.
The error is as follows:
It triggers whenever I clear the dashboard and add a new entry. It also triggers and clears Key1 after entering a Job Number into the key field, but only the first time entered. If I click onto the distorted resource field (not really a resource, it’s for end user familiarity) the drop down appears with the filter, but upon selecting any of the options, the error triggers again, but only once. The error also then happens whenever I click off of the BAQComboBox field onto another field.
The other issue I noticed is, no matter what option I select, it doesn’t actually update the ShortChar03 on the table entry. Whereas before when I didn’t have the BAQMarkup criteria set, it functioned fine – it’s just 50+ options to select is a little much for the user when we need the choice to be a valid option for another dashboard.
I feel like I’m missing part of the setup for BAQMarkup. This is the first time I’ve tried using it.