Something Filemaker Can't do

[Salesman0Gil]

I think I finally found something Filemaker can not do..

There are two fields Truck Run and truck Stop

I want to make labels, or make a list layout that will print, that:

1) has each Truck run (there are 8) a different color

2) Within each Truck Run, each Truck Stop a different color (there are 10)

Any ideas?

[Ender]

Calculating text color is easier in FM7, but you can do it with FM5. You have to make a calc for each possible color with definable criteria:

TS_ColorBlue = if(Truck Stop = 1,"Truck Stop 1","")

TS_ColorRed = if(Truck Stop = 2,"Truck Stop 2","")

...

Set the color of each field separately, and layer them on top of each other in the layout.

[Salesman0Gil]

Where is the TS_ColorBlue?:

I tried typing it in and got Filemaker can not find the field TS_Color

[Ender]

TS_ColorBlue is an example name of one of the new calc fields you will have to create to get this to work. The if() statement is what you would put in that calc.

[Salesman0Gil]

All right I going to be a newbie here.....

if(Truck Stop = 1,"Truck Stop 1","")

Says if the field Truck Stop = 1 then "Truck Stop 1", how does that change the text color???

[Ender]

Since you did't post your actual field names or types, I made up Truck Stop. The field color itself doesn't actually change. The overlapping calcs create the illusion of a changing field color.

[-Queue-]

It's cleaner to use Case if you have no alternate result.

Case(Truck Stop = X, "Truck Stop X")

[Ender]

Thanks Queue, I keep forgetting that.