Variable OLE Objects linked to a container

[teckert]

I have a large number of MS Excel files that i need to attach to Filemaker, preferrably without incorporating into Filemaker thereby minimizing the overall filemaker file sizes. Each of these Excel files are related to an individual in the database through their social security number.

what i would like to do is insert a link to the appropriate OLE obect into the container field for each record, having the container field change which excel file it is linked to based on SS# and potentially other criteria.

The link itself to an individual excel file appears to work fine, but sure would like to add the variability based on related resource.

i'm sure this has been attempted before, will also certainly welcome alternative solutions

thanks in advance