dinamic filter on lookup fields
Posted on 2004-03-25
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)