import path calculation

[fredley]

Currently I use filemaker developer 7. I am importing from 30 different databases, labeled database1.fp7, database2.fp7. I want to be able to select from a drop down list a number, and then be able to click import without typing in 30 slightly different file paths (I wouldnt mind doing it once, but at the moment I'm doing it a lot for different networks and different filepaths...) If you can do this in 8.5 please tell me and i'll upgrade...

Tom

[fredley]

Oh and incidently, is it possible to do the same for file references?

Tom

[IdealData]

FM8 introduced SCRIPT VARIABLES that can also be used in calculations. You can set the script variable to a filespec - so roughly speaking the answer is yes.

Try the freee evaluation download.

[fredley]

This looks like the answer, but i have a problem:

My filepath for import is set to:

filewin://rgs-guildford.co.uk/Shares/Teaching Resources/Modern Languages/audy/$Import

And I set $Import to be "export (" & database::ID & ").fp7", but I get the error message

Cannot find $Import

When Importing. For some reason it is not recognizing the variable...

Tom

Edited September 16, 2006 by Guest

[fredley]

Ok i've fiddled with it, got it working, however no joy for file references, still have to type those in manually...