EXAMPLE

I have a parent form call 'Sites'. 

I have a sub-form called 'Equipment'. The equipment form is a sub-form of the sites form.

Each site can have multiple equipment. 

1. Is it possible to display parent form fields in a sub-form report. Without having a lookup field to the parent form.

I'd like to see what equipment belongs to what site in the equipment report.

If that can't happen

2. I'd like to automatically set the 'Site name' for the subform as the parent form site name. Is this possible.

I've seen a few really old posts about similar issues however i can't seem to understand.

Cheers,

Justin