I am wanting to create a report, based on the parent form, but bringing in various fields from 3 sub-forms of this parent form.

I have created this type of report using the view link method, but the format of this is not satisfactory, and I want each field to show as a separate column in the report. (This is fine for one field alone, but not numerous)

The Subform is logically a one-to many relationship, so I am not sure why the subform columns do not show as options in the report creator, other than as a "link"

I have a bi-directional relationship on the sub-form to ID of the parent from using the existing relationship........

Am I doing something wrong?

Thanks

Kevin