Step one, finding the car type is easy. Step two, finding all matching colors regardless of car type can be a bit complex.
This doesn't sound like a query I'd actually want to perform in the real world. (Why would you want to find the record for an economy car just because it was the same color as one of the Ferrari records?) That suggests that you may be creating an example in place of the real data you want to search on. Be aware that such an approach in describing your problem can lead to less than optimum suggestions should the person making it base their response on details from your example that don't match the real situation.
That said, I'd use a relationship for finding the final list of records:
CarTable::ColorField = CarTableByColor::ColorField.
Where CarTableByColor is a new table occurrence of CarTable. ( Tutorial: What are Table Occurrences? )
Then this script will work, if the user first selects/enters the cartype into the global text field, gCarType.
Enter Find Mode
Set Field [CarTable::CarType ; CarTable::gCarType] // this will only work if Global storage is selected for gCarType
Set Error Capture[on]
Go To Related Record [show only related records; match found set; from table:CarTableByColor ; using layout: <current layout>]
Note: <Current layout> must be specified for this to work correctly should there not be any records found.
Note: for car records at a car dealership, this should work fine. If you are searching very large numbers of records, you may encounter a delay during the Go To Related Record step.
All the Ferrari's I have painted have come back with corrosion - I just want to check how the other cars are doing. Just kidding...yes its fictitious for clarities sakes. Amt of records will be no less than 500 on the first and maybe 100 on the second.
Thanks for the help - I was on the right track I think, but must have made an error - I'll check it closely against yours.