Automatically Insert Excel Files into Container Fields
I want to be able to connect specific excel files to specific records based on a field in that record. I do not care if I am making a shortcut or actually opening an excel file within filemaker. However, I would prefer just a shortcut.
My issue is that I cannot find a way to enter a field variable into the file name. It doesn't seem to work if I choose to insert file or insert object. Could someone please explain to me how I should go about doing this?