Forcing Dynamic Combo Boxes to re-query their list

AndySK

Hi Folks

This is my first post on this forum, so please go easy on me. I'm relatively new to AwareIM, but I have one problem which is driving me mad and I'm hoping someone has surely come across it before. I'm running AwareIM 8.6. Also, apologies if someone has already covered this, however I could not find any similar looking posts on this forum.

I have BO (called ProductItems) with a 'form' which contains a number of fields. Further down that form is a dynamic combobox which runs a query as follows...

FIND CreditBankHeader WHERE
CreditBankHeader.AccountNumber=ThisProductItems.Opportunity.AccountNumber
AND CreditBankHeader.Status='OK'
AND CreditBankHeader.Type='Contract'
AND CreditBankHeader.Unit=ThisProductItems.Unit
AND CreditBankHeader.OrderedOnOppConNumber=ThisProductItems.Opportunity.OppConNumber

Initially on the form load, 'ProductItems.Unit' is blank and thus the query for the combo box fails and loads nothing, as expected.

I've since come to the conclusion that Dynamic Combo queries only run on Form Load. Is this correct?

If I change the value of 'ProductItems.Unit', how can I get the combobox to refresh its list based on the updated value of ProductItems.Unit?

Thank you in anticipation.
Andy

Jaymer

hi, welcome.
away from desk, but there's a youtube video from AwareIM called Cascading Combo boxes (or similar). Check that

Also, a picture is ALWAYS helpful, in this case of your screen

PointsWell

If you are already referencing another BO then you'd probably be better creating a relationship attribute and then filtering it based on the in context BO

Eg
ProductItem.psCreditBankHeader

customaware

Are you using Fetch All Records at Once?

Al At Once.jpg

AndySK

Hi Folks
First off, thank you all for taking the trouble to offer some help.
The two business objects are currently not related. Do they need to be in order for this to work?
Also, eagles9999, I'm not seeing the same properties on my attribute that you are seeing...

I am on version 8.6 build 2937
Thank you all.
Kind regards
Andy

AndySK

Hi All
I've now fixed this.

Thanks to Jaymer for the heads-up on the video. After watching this, things seemed to slot into place in my brain 🙂

I've created a new attribute of type 'CreditBankHeader' but this doesn't have any relationship set up (by design). Then following the clues given by you chaps, I've made this new attribute a combo-box which loads the data based on a filter/query.

Now the form looks like this and the combo shows the selectable results as expected. (Cosmetic work pending 😃 )

A massive THANKS again to you all.