how to auto fill a field based on number entered?
I'm a filemaker, and overall database, newbie. I'm running version 7.0v2, Mac OSX 10.4.11.
I'm trying to get a field to be a certain color (filled with) based on the number entered in said field. An example would be, if "3" is entered, the field turns red; if "4" is entered, the field is black, etc., etc. I would also like the number entered to also be visible, preferably white in color to help with the contrast of the field color. This will not be shared on a network and I don't have any current plans to take it to the web.
Thank you so much for your assistance.