AnsweredAssumed Answered

Performing a find in a script

Question asked by TheNovice on Oct 29, 2016
Latest reply on Nov 6, 2016 by BruceRobertson

Hello All,


I’m on FM 14. I have a table called Periodicals that contains a field called Title. I want to create a separate table that will contain only the titles (+ and ID for each). So to copy all the titles in that new table, I have written the following script. Of course once the new table contains one occurrence of a specific title, it does not need a second one, and so my question is what am I missing in the script to avoid duplicates of a same title being created in my new table? I know the script must perform a find at some point but this is where I get stuck. Help would be greatly appreciated.


Go to layout [‘<Periodicals’>]

Go to Record/Request/Page [<first>]


     Set Variable [<$title>]; Value: Periodicals:Title

     Go to layout [‘<Periodicals’>]

     Perform Find [Restore]


     New Record/Request

     Set Field [Periodicals::Title; $title]

     Go to layout [‘<Periodicals’>]

     Go to Record/Request/Page [Next; Exit after last]

End Loop