Hi
I am looking to develop a database to collate all documents, such as Risk Assessments, COSSH or any other file that relates to their own individual project. I know how to create a list box of all projects and to be able to double click an item in the list box to open that specific record. The next part is where i am unsure, when the specific record opens on a new form I can display the relevant information at the top of the form, such as project name, project owner, but what would be the best way to display all relevant files associated with that project? Should I use another Listbox or a Subform. I know i can set up an attachment field in a table, but I would prefer to list all the files and have radio buttons to filter the list so show a specific type of file, say "Risk Assessment" or "COSSH". Then lastly to be able to click on a file and open it regardless of its format, IE, Word, Excel or whatever the file type is. Just to note, these files are stored on a network drive which i have access to. Thanks in advance for your support.