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
Forcing Dynamic Combo Boxes to re-query their list
Re: Forcing Dynamic Combo Boxes to re-query their list
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
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
Click Here to see a collection of my tips & hacks on this forum. Or search for "JaymerTip" in the search bar at the top.
Jaymer
Aware Programming & Consulting - Tampa FL
Jaymer
Aware Programming & Consulting - Tampa FL
-
- Posts: 1462
- Joined: Tue Jan 24, 2017 5:51 am
- Location: 'Stralya
Re: Forcing Dynamic Combo Boxes to re-query their list
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
Eg
ProductItem.psCreditBankHeader
-
- Posts: 2413
- Joined: Mon Jul 02, 2012 12:24 am
- Location: Ulaanbaatar, Mongolia
Re: Forcing Dynamic Combo Boxes to re-query their list
Are you using Fetch All Records at Once?
Cheers,
Mark
_________________
AwareIM 6.0, 8.7, 8.8, 9.0 , MariaDB, Windows 10, Ubuntu Linux. Theme: Default, Browser: Arc
Upcloud, Obsidian....
Mark
_________________
AwareIM 6.0, 8.7, 8.8, 9.0 , MariaDB, Windows 10, Ubuntu Linux. Theme: Default, Browser: Arc
Upcloud, Obsidian....
Re: Forcing Dynamic Combo Boxes to re-query their list
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
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
Re: Forcing Dynamic Combo Boxes to re-query their list
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.
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.