Hello Everyone,

I am facing a problem that maybe someone has had before and will be
able to assist me.

I have a database that has information about a student and his test
responses. Like a scannable test.

Then I have an application that analizes the test, so this application
has tables Student, Test_Result and so on.

I need to have some fields from the first file (the file that has the
whoel information combined - scannable test) be exported to STUDENT
table in my application file and some fields be exported to TEST_RESULT
table also in my application file.

TEST_RESULT is a join table and contain the following fields:
-STUDENT_ID
-QUESTION_ID
-CORRECT_ANSWER

So, for each field on the scannable form, I need to create a new record
on TEST_RESULT and put the correct information. What I want to do is
use the script function Go to Next Field and while next field exist I
will create a new record on my table TEST_RESULT.

The problem is even setting up a global variable it ends up being
destroyed when I move to the other file to SetField using the value of
the global variable, and I loose that value. Also tried using
copy/paste, but I think different files use different clipboard
areas...

It is important to know that since the number of questions on the Test
can vary, I can not setup a table for that in my application with a
fixed number of fields, the number of fields is defined in the
beginning of the application and saved on a global variable to keep
track of it throughout the program.

Thanks

Thiago

See my earlier post "Re: Complex Relationship help needed" for an
example of managing link table and copying values between fields.
Michael Paine

Thiago Jorge wrote:

That is exactly what I am trying to do, the only "small" difference is
that when using different files the global variables are not shared
among the files. So when I go back and forth between my files my values
for the global variables or even the clipboard (using copy/paste) are
lost.

And I do need to use different files.

Thanks

If you create a true global field eg.
make a text field click on the storage option and checkmark "global"
you can set that field from any file, not just table but file, and it
will have been updated for all files.

The clipboard is shared amongst all applications eg. if I copy
something in Word and press paste in FileMaker, I get the data copied
from Word.
I'm not sure what you're copying and pasting but the clipboard
shouldn't loose it's data. The only thing you can't do is copy a
container field and paste it into eg. a date field.

I would offer suggestions on how to do what your trying to do but I
don't understand your setup. You say you have a database of a students
and their test response. Then you say you have an application that
analyzes the responses. Are these different applications (eg.
FileMaker & Real Basic) or are they just 2 different FileMaker files.
If they are just FM files, why not import the data from one into the
other? It would also be useful to know what version of FM your using.