I try again

[Alvin Hansen]

I have 3 table:
1: Movie
2: Actors
3: MandA

First table : id and name movie
Second table : id and name actor
3. table Id from Movie table and actor table

Now i make a form based on table 3 : MandA
in this form i have a combobox with Movies there send the value to a field
on the form for movies into table MandA

And a second combo box with actors there send the value to the field on the
form for actors into table MandA

So far so good: Now I want that the second Combobox only show the actors
there not are in MandA where movie ID = Combobox1. I can all about using
Combobox and show waht actors are in MandA based on Combobox1 this is OK.

Hope some one understand

Best regards Alvin