Foreign Keys

Hello everyone

Just asking on how to view a foreign key in 3 tables.

I have attached a pictured, in the picture, in the shape table there is a foreign key object_id from object. and the object have a foreign key color_id and it is connected to color.

In the color_id of the object I will get the color_name from the color.

while in the in object_id in the shape I will not get the object_name but rather the color_name of the color that the oject get from the color.

I want to get the color_name without connecting the shape from the color