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

Well, you don't have to use a view, but if you plan to show fields from more than one table, you will either have to call a SPROC, view, or call a SELECT statement that populates the BO with all of the data. So anyway that you elect to do this if fine. So first, get your data into the BO.



Next, you will need to either create custom field properties (which there are a lot of samples on how to do this), or you can take another approach if there will be a lot. If you have the DDT (Database Deployment Toolkit) you can go in and create a structure that will be used ONLY for mapping a BO structure. You never have to deploy the DDT package, it is used solely to create all of the custom field properties for you. You can then populate the BO with the data that would match this schema and you don't ever have to manually code the custom fields. This is an approach that I used from time to time for this very purpose.