AnsweredAssumed Answered

I'm trying to Copy Specific Data from One Database to Another

Question asked by jthomas on Jun 28, 2012
Latest reply on Jun 28, 2012 by jthomas

I have 2 Filemaker Pro Databases. One database is called otto_go and the other is Question Bang Go. I am trying to copy a "Found set" of data from "Question Bank Go" to Otto_go. he following is a portion of the script from Otto_go:


If [ Get ( FoundCount ) = 0 ]

Perform Script [ “GetNewSurvey” from file: “Question Bank Go”; Parameter: $$SurveyTypeID ]

Go to Layout [ “Survey_Go” (Survey_Go) ]

Close File [ “Question Bank Go” ]

Import Records [ Source: “file:Question Bank Go.fmp12” ; Target: “Survey_Go” ; Method: Add; Character Set: “Windows ANSI” ; Field Mapping:


Script for Question Bank Go :"GetNewSurvey"


Go to Layout [ “SurveyBank” ]

Set Variable [ $SurveyTypeNumber ; Value:Get ( ScriptParameter ) ]

Perform Find [ Specified Find Requests: Find Records ; Criteria: QuestionBank::SurveyTypeID : “$SurveyTypeNumber” ]

[ Restore ]


When I run the script I get all the records in the QuestionBank table.


Any suggetions would be appreciated.



I'm new to Filemaker. I normally program in Access basic.