admin grid show data from foreign table

[crazyfoolmurdock]

Hi guys,

 

I was hoping someone could help me with my problem:

 

I am creating a module for prestashop and have created the admin back office tab so that I can add things to the module's database table. One of the table attributes is actually a foreign key from another table and I would like to display more meaningful information rather than the foreign key in the admin grid. What would be the best way of doing this?

 

Thanks to anyone who replies