i have a Query called Personell which consists of
tblPersonell; "Personal Number (key)". "FirstName". "LastName". "Rank"
tblPersonellRanks; "RankCode(key)". "RankName".
now the query works fine perfectly i made the same thing with qryDrivers
tblDrivers and tblDriversRanks have same things but...