My Students table has 5 skill fields (skill1, skill2, etc) that lookup to a Skills table for the name of the skill. The Skills table has an auto number key field and a skill name field (eg., Sauteing). When the Students table is open in datasheet mode, or in a simple query of just the Students table, the skill name displays in the 5 Students Table skill fields. But when another query is added to this simple query the skill table (foreign) key is displayed in the 5 Students table skill fields (skill1, skill2, etc).
I would appreciate learning possible causes of this problem and how to display the skill name instead of the skill auto number key in any query, simple or complex.
Thanks