I'm working on a project where we get a daily FTP dump from a company with a CSV and multiple PDF files. I already have a script to import the proper CSV from remote depending on a date field, but I need a way to list the corresponding PDF files. Each file has a stamp in the name that relates to one of the fields, but there's other extraneous data in the filenames that have no relevance so I can't automatically reference the files.
Also having trouble setting up the necessary related records to make this relationship even work. Already looked at SuperContainer, but that still only limits to one file per container.
I'm on FM Advanced 16 on Windows 10 64 bit. Any help would be amazing- thanks!