Subject Re: Filter on 2 fields with lookup
From Mervyn Bick <invalid@invalid.invalid>
Date Wed, 27 Mar 2024 18:08:22 +0200
Newsgroups dbase.getting-started

On 2024/03/27 13:07, Dirk C wrote:

>   is working as long the value of the combobox is in stammdat.dbf
>   when the value isn't, cannot filter any more, even i Null the filter
>   even i want to get the names from stammdat from the selected country
>   with the value (selecteren) so i can pointed the correct segment value
>   for now main cornern is to filter
>    or is it better to use sql statement ?
> can you have a look to the attached file
> thanks

Dirk, I'm afraid the form is simply too complex to work out what does
what without being able to run it.  A screenshot of the form with a
description of what you want to change in the display may help me
understand what you're after.

Many years ago I moved all my own data to Firebird so I only use SQL for
my own code.  Even before that I used SQL in preference to the dBASE DML
commands.  Instead of setting filters I use parameter driven queries to
create rowsets of the records I want.