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.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Outcomes