I have two tables:



exchange(exc_code,exc_desc) (Exchange code and exchange description)



exchange_rate(exr_code, exr_valu, exr_date) (Exchange code, excange rate value, exchange rate date)





I want to display on one grid the following information: (exr_code is a foreign key to exc_code)



exr_code,exc_desc,exr_valu,exr_date





What is the best way to achive this? I tried to read the forms and manages to create a new custom field on a BO but still it cannot be displayed in the grid.



Could you please give me a simple example?



Best Regards