I try to create a Query with data from two tables. I want the result to be every record from table Wv007Transportor
and only records from W729SalgsHode where Wv007Transportor.Klientnr = W729SalgsHode.Klientnr. For some reason option 2 is not possible in the linking dialogbox. Can this be done in a MS Query? It's not a problem when I create a view in Access.