View displaying one-to-many data


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?