I have one table Clients and this has a relationship to Files.
One client can have many files.
I have a subform Files on the main form Clients
What I would like to do to is to print the contents of one record of the sub form.
I need to make a report, prob based on a query and then have a filter in the report to filter one client AND that particular file
So as to print all the clients details and the details for ONE file.
Ideally select the file record from a double click from the file records.
Assistance please appreciated.