Multiple file search and report
I am completely new to Filemaker, I would like to know if what i am trying to achieve is possible.
I have a spreadsheet with a list of ID numbers, and an index from neofinder which has the file name and file paths of files on a server. ( this is exported as a spreadsheet also)
I am trying to pull a report which will use the ID number and search the File Name column of the neofinder index spreadsheet. Giving me a "yes or No" as to whether a files are held for that ID
I would also like to pull a report of all the file paths for that particular ID into another report.
Any help you could give me would be greatly appreciated.