I am trying to add a Look-up Field onto a Sub-Form that appears in the Parent Form, BUT the Parent Form Field I require is also a "Look-up" field, linking this to another table in my App.

I tried creating a Look-up to the Linked table (Not my Parent table), but this does not allow me to run reports with data from my parent table.

Any assistance?

Thanks

Kevin