scripts finding related records of one field in a recordset
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.
id is 12, TypeField is Ferrari, ColorField is red
ID is 44, NameField is Capri, ColorField is red
ID is 789 , NameField is Ferrari, ColorField is yellow
ID is 122 , NameField is Camaro, ColorField is blue
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