I have 2 fields in one table that I want to combine into 1 field in an unrelated table in teh same file

Now I have it set up using the import command, but it the file name changes i have to rewrite the script

is there a better way to do this or is there a way to specify that it is coming from the same file no matter what the name is

He A -

You need to rename the file with FileMaker Developer. I am not aware of any dynamic way to specify the import source file. Renaming FileMaker files manually can create all sorts of problems (like the one you bring up in this post), so Developer is the best tool for the job.

ltr,

j

You might consider setting a global with the concatenated contents of the two fields. Then switch to your unrelated table, create a new record (or find the record which should house the data) and simply use a Set Field [ ] script step.

Globals can be accessed from anywhere, even unrelated tables.

I have 2 fields in one table that I want to combine into 1 field in an unrelated table in teh same file

Sorry for being such a busybody, but could you explain the reasoning behind - I might be in for a lesson. In my ignorance could the same be done with an unstored calcfield in the original table ...or???

Though I'm aware of wan'ing a solution might request as short as posible indexes (portal sorts) if they're likely to work with global values in a calc' but is it really the issue here??? ...or is there other compelling reasons for establishing a system which is tough to syncronize??

--sd