combobox list query if criteria is NOT required

[jpatrick]

Hi! I have a combo box working fine but want to filter the list based on a second combobox IF the second cbo has been filled in. I do not want the second cbo to be required. Actually, I have a third cbo also so what I really want is:

#1- the primary cbo to not be filtered at all if both the second and third cbos are BLANK
#2- the primary cbo to be filtered by the second cbo criteria IF the second cbo is NOT BLANK
#3- the primary cbo to be filtered by the third cbo criteria IF the third cbo is NOT BLANK

I have a 'got_focus' on both the second and third to make the other blank to prevent both from being NOT BLANK at the same time. They can both be blank for #1 above. Thanks in advance!

 

[Uncle Gizmo]

When you say "primary" I imagine that that refers to the first combo to be filled in... is that correct?

Sent from my SM-G925F using Tapatalk

 

[jdraw]

The subject involved is usually Cascading Combos..
But it does seem you may have some logic to resolve.
See this from Baldyweb
and
http://www.datapigtechnologies.com/flashfiles/combobox1.html
http://www.datapigtechnologies.com/flashfiles/combobox2.html

 

[jpatrick]

When you say "primary" I imagine that that refers to the first combo to be filled in... is that correct?

Sent from my SM-G925F using Tapatalk

Hi! By Primary I mean the combobox that will display the final results. If you don't want to filter by the options in 2 or 3 you could fill it first. Your options are as follows:

#1 - select primary and leave 2 and 3 blank (primary will run it's usualy query to show unlimited results)
#2 - select second then primary (primary results will be further limited based on what you select in 2)
#3 - select third then primary (primary results will be further limited based on what you select in 3)

I know how to make a first cbo required so it cascades to the next cbo but I want 2 or 3 to be optional, not required, and for users to have the 3 options above.

 

[jpatrick]

The subject involved is usually Cascading Combos..
But it does seem you may have some logic to resolve.
See this from Baldyweb
and
http://www.datapigtechnologies.com/flashfiles/combobox1.html
http://www.datapigtechnologies.com/flashfiles/combobox2.html

Thanks! I'll check those out and report back.

 

[Uncle Gizmo]

Let's imagine your primary combobox Returns a search for a city. One of your other combo boxes providing a level of search for State, and the other would provide a search for Country. In a typical cascading combo box system you would first select the Country then the State and then City.

Now, I don't think that's what you want, I think you want something slightly different.

If you could explain the results you expect in the terms of Country, State, City then that might help with understanding what you want.

 

[jpatrick]

Let's imagine your primary combobox Returns a search for a city. One of your other combo boxes providing a level of search for State, and the other would provide a search for Country. In a typical cascading combo box system you would first select the Country then the State and then City.

Now, I don't think that's what you want, I think you want something slightly different.

If you could explain the results you expect in the terms of Country, State, City then that might help with understanding what you want.

Hi! Exactly like that but neither County or State would be required, you could choose one or the other or neither. So...

#1 - all cities
#2 - cities limited to a country
#3 - cities limited to a state

If I wanted to limit it I could choose a county OR a state. If I did not want to limit I could see all cities by leaving country and state blank.

 

[Uncle Gizmo]

So you will NEVER want to use both Country and State in the same cascade?

Sent from my SM-G925F using Tapatalk

 

[jpatrick]

So you will NEVER want to use both Country and State in the same cascade?

Sent from my SM-G925F using Tapatalk

Not needed but if it makes things easier it is fine to allow that option as well.

 

[Uncle Gizmo]

Have you got this sorted?

 

[jpatrick]

The subject involved is usually Cascading Combos..
But it does seem you may have some logic to resolve.
See this from Baldyweb
and
http://www.datapigtechnologies.com/flashfiles/combobox1.html
http://www.datapigtechnologies.com/flashfiles/combobox2.html

Baldyweb pointed me in the right direction. Thanks!

 

[jpatrick]

Have you got this sorted?

Yes, thank you! I'm sorry I forgot to come back here to post. The baldyweb suggestion from jdraw pointed me in the right direction. Thanks again!