Data Access Layer and GridView for foreign key values

[ZLA]

Is there a standard way to display foreign key values in a Gridview using generated data access classes? I want to be able to sort on the displayed value (a field in the foreign key table), not the foreign key itself.

Do I just change the LoadForWhatever routines to include the foreign key columns or do I need to change the class's underlying column names?

Thanks.

[mazhar]

This sort of operation will need SQL JOIN or more complex queries. LoadForCriteria is designed for simple queries involving just single table. In your case you can write your custom load method with your complex SQL query and then use that method for your custom sorting etc.