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

    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.