View displaying one-to-many data

Hi,

Can anyone help please.

Is there any way around being able to display columns from an associated table (one-to-many) within Dynamics Views? I have a custom table linked to the Opportunity table (1:N) and the users would like to view columns from the custom table related to the Opportunity within a View. I have created the View within XRM Toolbox - Save View as - but when I look at the View in Dynamics at Opportunity level I can see the column I defined within the XML and data is now showing but only one record per Opportunity when there are multiple records per Opportunity. Has anyone managed to get around this?

Thanks,
Adam