AnsweredAssumed Answered

scripts finding related records of one field in a recordset

Question asked by HB on Jan 19, 2011
Latest reply on Jan 19, 2011 by HB

Title

scripts finding related records of one field in a recordset

Post

Hi

I am a beginner. I am making a script to find a set of records that are related to one field in another set of records.

ie

table: Cars

record1

id is 12, TypeField is Ferrari, ColorField is red

record2

ID is 44, NameField is Capri, ColorField is red

record3

ID is 789 , NameField is Ferrari, ColorField is yellow

record4

ID is 122 , NameField is Camaro, ColorField is blue

etc

I want to do a search that finds all the ferrari's, then find all the cars sharing the colors of the Ferraris'

-->in this case should eventually show 3 records

Outcomes