I am building a database for kitchen cabinets.

Part of the description is context, ie, what is the adjacent condition on the left and right side of each cabinet.

A cabinet can either terminate into another cabinet, terminate at a wall or have an exposed end panel.

I would like to link an object ( colored rectangle) to the side of each cabinet and have this object change color based upon a selected value from the adjacent condition value list.

Can anyone tell me how to accomplish this?

Thanks.

Hi Jarvis,

Create a global container (two if the left and right sides use different criteria or value lists). Paste your rectangle graphics (one for each color you want) into each rep then create a calculation cFlag (unstored, container) with a Case statement something like:

Case(YourDisplayCriteriaHere, GetRepetition( gContainer, 1), DifferentConditionHere, GetRepetition( gContainer, 2)) ... etc.

Then place your cFlag on your layout. If you need help with your Case statement, let us know.

Cheers!

LaRetta