Thanks Ray, but how would I filter the two recordsets? For instance the rsGolfumbrella would have the following columns: itemId, itemName, itemDesc, itemPrice, itemQty, itemColor with a recordset being filtered on the itemId. So what columns should my second table have? (The GolfUmbrellaColors) and what MySQL statement would I use to filter this? Thank you!!!