inserting data

[redhotkoi]

I'm new to FM help would be greatly appreciqated. how do I create a "check box" when the box is checked a price will automaticly appear in another box?

Thanks Andy

[andygaunt]

Well,

you could create a calculation field.

If (check box = "yes," "$xx.xx", "")

Where "yes" is the value of the checkbox and "$xx.xx" is the value you want to appear.

format as a number.

However, if you have multiple options in your check box, you would then need to find that string

If (patterncount(check box, "yes"),"$xx.xx", "")

Do these help at all

[redhotkoi]

Andy

Thanks you for your help that is exactily what I needed. I defined a field with a check box value list that returned yes. Then a calculation field with formula that you wrote. It took me a little bit to figure out that the comma after yes should be after the quote. I am glad I am not a programmer. Those typeo would drive me nuts.

Thanks

Andy

[danjacoby]

OK, there are too many people named "Andy" on this board!

[andygaunt]

Andy, glad it helped.

AS to the typo, ooops

When typing straight into the forum, sometimes you miss it, but when doing in filemaker it becomes inherently ground in as to where these should be.

[andygaunt]

Dan,

not getting jealous are we. You can have your name changed if you would like, We could start ot call you Andy Dan

[danjacoby]

Gee, Dan Andy G...

This is beginning to sound like Monty Python's "Four Guys Named Bruce".

[andygaunt]

Or the "Four Guys Named Bruce"

[andygaunt]

Oops, forgot to change that. DOH!.

"The four guys named Andy"