2 Replies Latest reply on Jun 19, 2013 9:40 PM by rmulder

    Using fields from a found set in one table to perform find in a related table

    rmulder

      Title

      Using fields from a found set in one table to perform find in a related table

      Post

           Hello,

           I am trying to write a script that will allow me to extract a list of field values from a found set in one table and use these values to perform a find in a related table.  For instance, I might have a found set of street name records that match a particular suburb in one table, and I then want to go to a related table to perform a new find in that table, using the list of the street names that were returned in the find in the original table.

           Can anyone suggest how I go about doing this?

           Many thanks,

           Raoul