2 Replies Latest reply on Jun 28, 2012 12:58 PM by jthomas

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


      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.