Good morning,
I am working on a report that is giving me some trouble and hopefully someone can assist. I have a form that provides data entry of a file name that among the fields on it, contains the following:
file_location_server
source_folder_Server
Destination_Folder_Server
Archive_Folder_server
All of these fields are lookups to another table called server and can contain either the same or different server ID's.
I am trying to create a report that would allow a user to lookup a server name and display all associated files, whether it is because that server is the value for any of the following fields,
file_location_server
source_folder_Server
Destination_Folder_Server
Archive_Folder_server
Can someone help me get this setup. I am thinking I need to create a query first, but not sure what I should create to get this to work.