hi, all.

i have two databases: abc & xyz. I will use abc to gather data that will come from radio buttons 1-5 for about 200 questions. i then want a button at the bottom of abc that when clicked will submit the data, then open database xyz, which is a series of essay q&a's. i need to keep the databases separate b/c i will be exporting this info to excel for others to use and they do not want overly large rows which would be created by the essay questions. this is being done over the internet, so it would also be nice if the person taking the quiz would not have to re-enter the password to go from one database to another.

any quick help will be appreciated as they need this within 24 hours (yikes!)

thanks,

carlos

When you say "over the internet," you mean web publishing? You might want to ask questions like this in the CDML or Using FileMaker Online forums.

That said, in standard (non-web publishing) FileMaker usage, you would just create a script in abc like this:

Set field [gQuizID, QuizID]

Perform Script [external, xyz]

This would reference a script in xyz like this:

New Record

Set field [QuizID, abc::gQuizID]

Go to field [whatever]

FYI, a password entered for one database will be automatically used in any script or relationship that references another database. The user won't have to re-enter it.