Populating a seperate file with select records

[schotja]

I've always just used a simple copy/paste script but the more i investigate fm7 I've realized there might be better options. I'd like to populate a seperate file with a dozen fields from select records. Am i on the right track implimenting a calculation like a "get field" in the script instead?

Any rules that i whould be aware of or tips?

Thanks

Jared

[-Queue-]

Set Field will work for you, assuming the records to be set are uniquely related to the current record. You could set a global in the current file with the id from the second one, then using a relationship from the global to id, set the fields in the related file. Once you move to the next record, simply set the global to the next desired id. This can be easy or relatively easy, depending upon how many related records there are.

I don't think you would need GetField, unless your function was dynamic.

[schotja]

You mentioned "get" will work but is there a better way for me to look at that will put the fields into the second file? Something more efficient??

Thanks

Jared

[-Queue-]

Set Field using relationships would be the most efficient way I can think of, unless I'm missing some detail you're not including.