>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.

Change orange = to orange in