We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

dinamic filter on lookup fields

gully1
gully1 asked
on
Medium Priority
492 Views
Last Modified: 2010-04-05
Hi,

Want to make a lookup field that depends where the possible values depends on another fields's value.
I set the lookupdatasets filter property and set the filtered property to true as well. Even tried Refresh still nothing happened. Got the same list in the lookup field. How could i solve this problem?

I tried to use customconstraint too but didn't work.

for example one field is country and the other is town
if someone picks country he can pick a toen only from that country (only that the connection is much more complex : depends on other tables of the dataset)

thanx
Comment
Watch Question

Commented:
May be You should use TQuery.
Give some more details. What do You exactly mean by lookup field
Top Expert 2004

Commented:
disable the lookupcache-property (-> false)

meikl ;-)

Author

Commented:
Well, I set the lookupcache to false yet the list didn't refresh.

Top Expert 2004
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
To be more precise, I have a dependency table which is in fact a list of pairs of the elements of two other tables. Not foreign keys but strings still it defines the other tables elements . So when the users picks up one element of the first table i want to show him in my lookup list of the other table only those that are linked to it (has a pair of the two in the dependency table).
I simplificated it a little, but i guess if i got a solution for this, I can solve the problem.
What i did was:
When the first field changed i collected the linked objects from the dependency table and set the filter.

Author

Commented:
I use SQLDirect (changed a bit).
A query inherited from TSDQuery(inh from TQuery).

Author

Commented:
Sorry if i didn't answer your question. It doesn't use BDE.

Author

Commented:
Ok I found the solution. Closed the lookupdataset, set a new SQL for it and reopened. It worked.
Probably filtering has no effect on the lookuplist.

Author

Commented:
no thanks
i have enough

(what else can you show me :))
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.