>I have a form which displays information about a particular record. When I click on my navigation buttons I want to display child records in a listbox which is bound to another table using the field artikey. In the click event I use a set filter:
>
>
>SELECT article
>SKIP -1
>cArtikey=article.artikey
>
>SELECT cmscomp
>SET FILTER TO Artikey=cArtikey
>
>
>But when I change records nothing happens in my listbox. Canybody help me please?
Try:
SELECT article
SKIP -1
cArtikey=article.artikey
SELECT cmscomp
SET FILTER TO Artikey=cArtikey
GO TOP
But I will use SQL Statement instead of SET FILTER
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.