is there a way to change a field's color based on how many records there are in a related db?

i have a jobs db and a client db. i would like to have maybe 5 different colors which allow me to gauge the customer's number of jobs in the jobs db. ie. customer one has 5 jobs, i would like for their name to be in blue. customer 2 has 10 jobs, i'd like for their name to be green. etc.

any ideas?

thanks.

josh

YES AND NO.

There are two solutions that I use in my layouts.

Solution 1 :

First is made of calculation fields instead of your native field for the name.

I make it simple :

c_shownameinRed = Case(Your relation::Nb records = 5, "Name", " ")

c_shownameinGreen = Case(Your relation::Nb records =10, "Name", " ")

c_shownameinBlue = Case(Your relation::Nb records =15, "Name", " ")

While in Layout mode, fomat calc 1 to be red, calc 2 to be Green, calc 3 to be Blue, or italics, or UpperCase,...

Then place these fields with transparent background one over the other and use this calc instead of your field. Is it possible for you ?

Solution 2 :

Use containers fields and set it contents to suit the background of your field according to a calculation. As you noticed, the text is still formated, only its background change.

Hi Josh,

Attached is a sample of how to change the background colors.

HTH

Lee

ChangeBackground.fp5.zip