Get Name of Source Data File to Appear with Records
I need to import hundreds of .txt files into filemaker that comprise the raw data for my database. These records are imported from a client, who does not specify the date of the file. I need to create a field that will indicate the name of the source file (which includes the date). This is imperative as the data contained in the records changes and finance needs the dates of these changes. Pls help, tnx.
Note: I don't think a global container field is going to work. I need to combine these files into one table with each set of records from a file bearing their own individual file name.