>I still can't get used to subqueries. This code is in a click for a print button: SELECT red,yellow,blue FROM MainTable WHERE orange = ... where orange matches records in a previously created sql from MainTable under the name MyCursor
>
>I tried SELECT red,yellow,blue FROM MainTable WHERE orange = (SELECT MyCursor.orange) ... but I only get one record.

Try:

SELECT red, yellow, blue FROM MainTable WHERE orange IN (SELECT orange from MyCursor)

(it helps to use the right syntax)