When retrieving a record with a foreign key field it is desirable to display a field from the Primary Key table.

What is the best practice for doing this using the MM.Net framework?

I modified the MM.Net generated stored procedure and Data Access Layer to retrieve the desired field. Is this the acceptable method?

Example:

Crew table:
CrewPK
Name
CrewTypeFK
.
.
.

CrewType table:
CrewTypePK
TypeName
.
.
.

When I display the Crew table information I want to show the CrewType.TypeName instead of the Crew.CrewTypeFK value.