Dependent dropdown chain

Hi,
select color.colorgroup in the Category control dropdown box, product.colorgroup in the Category field dropdown box on the "Edit as" settings dialog on the Visual Editor tab for the Color table.

Thanks the reply Jane - but I don't think I did a good job of explaining my situation.
I am designing the add page for table Order and specifically filling fields:
Order.manufacturerid

Order.productid

Order.productcolorid
-Order.manufacturerid "edit as" is simple lookup from Manufacturer table.

-Order.productid "edit as" is dependent lookup with Link Field Product.id, Display Field Product.name, Category control Order.manufacturerid, Category field Manufacturer.id

-Order.productcolorid "edit as" is dependent lookup with Link Field Color.id, Display Field Color.name, Category control, [[this is where my problem is]], Category field [[this is where my problem is]]
I need a list of all colors where Product.colorgroup matches Color.colorgroup. If I still need to go to the Color table and change the "edit as" for Color.colorgroup please tell me what should go into Link field and Display field as well as Category control and Category field.
Thank you,

Peter

Peter,
I recommend you to add new field to the Color table (ProductID, for example).

Then select Color.id as Link field, Color.name as Display field, Order.productid in the Category Control dropdown box, color.ProductID in the Category Field dropdown box.