Multiple check boxes

[George]

I am working with a quote database where the particular quote could have special instructions if the item being shipped is extremely heavy, tall or wide (it's for a trucking co that hauls huge pieces of cargo). I have created a field that includes 3 choices as checkboxes (heavy, tall and wide) and if the particular item is heavy and tall, I am trying to get a paragraph of text instructions to print out at the bottom of the quote. One paragraph would be for heavy item instructions and the other would be for the tall item. Problem is that when I check both boxes, heavy and tall neither paragraph prints.

[Vaughan]

How are you making the paragraph print?

[George]

I was thinking in terms of a calc field for each of the 3 checkbox values, and then another calc field that concatenated the above.

ie. If Tall is checked then print "The cargo on this load has a height greater than 15 feet and therefore has to take this route..." If Heavy is checked then print "The cargo on this load is greater than 5 tons and due to roadway restrictions, you must take the X-Interstate..."

[Olive]

Hi,

I encountered the same prob... Here's what I did, but maybe there's a simpler way.

(I'm working on a frensh FMP version, so I'm not sure about the exact terms, I hope that'll be OK)

1- create a calc field that replace the return sign (

[George]

Thanks for the reply, I cannot find anything that "looks" for the text as you describe. And specifically can't find a function called Occur or Occurrence. Would appreciate someone pointing me in the right direction for some function to search for a word in a field. If I can find such a function Olive, I think your suggestion will work. I have tested removing the

[Kurt Knippel]

Pattercount is probably what he is referring to.

[George]

Olive and Capt. thank you both. After using the

[Vaughan]

To reduce maintenance in the future, don't "hard code" the messages into the calculation. Instead, create global text fields -- one for each message -- and use the global field in the calculation. This will make changing the messages relatively easy in the future.

If(PatternCount( sub_checkbox , "Height")=1, gMessage1,"") &

If(PatternCount( sub_checkbox , "Weight")=1, gMessage2,"")

[George]

Thanks Vaughn, I will do that to the real set of data, I am just working with an old copy.