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.