calculation field as match field

[GlennC]

Hello. I'm trying to import data from another FM file to regularly update multiple records, using a calculated field as the match field in both the source and destination files. The manual states that a match field cannot be an unstored calculation, and I took that to imply that a stored calculation can be used. But in the import dialogue all the calc fields (including the one I want) are greyed out. What does this all mean?

I can only get an appropriate match filed by joining 3 fields - Field A&Field B&Field C. This field will match with one record in the other file, from which I need to get the data from several fields in that record. I need to repeat this process four different fields per record in the destination file, and with each of them only finding the correct match by joining 3 fields. So I was planning to do four seperate update imports within one script, each with the required match field.

The source file is a temporary holding file, so I'm thinking that means some other form of lookup isn't going to work.(?) How can I make this happen?

Glenn

[GlennC]

OK, to answer my own question, I've discovered that by selecting the update option first, the calc fields are no longer greyed out.

Does the proposed method sound like the best way to go, though?

Glenn

[GlennC]

Here's the next problem - I can't have four seperate imports without the dialogue screen each time, because FM just remembers the setup of the last import, and the fields need to be changed for each one. Manually setting the dialogue screen each time is not a feasable option. I think my plan has come unstuck. What should I do?

Glenn

[cjaeger]

you can save 1 import per script, check "restore import order". and you can check "without dialog". The last executed import will be saved with that script. you may have to make 1 subscript for each different import, then call from a 5th script in order.