Calculated field shows keyID instead of value.

[jonasjacobs87]

Hi all,

I have a table dogs (tblHonden) in which i look up breed in a table (Ras, tblHondenrassen) and owner (tblKlanten).
When I try to calculate a field showing [Naam] & " - " & [KlantID] instead of Max - Jonas Jacobs I get Max - 2. The 2 refers to the [KlandID] but instead of showing the name it shows the actual keyID.

Any clue on how I can fix that? I would like to use the "Max - Jonas Jacobs" field in frmHonden to navigate to records on that form.

 

[arnelgp]

Here you may try