FM8.5

I am trying to create an Invoice field with a calculated result. When
a Contact field is valid (a tax number exists) the Invoice field
checkbox defaults to Y, otherwise N.

My attempts do not work. Can anyone help.

Thanks
Matthew

On Nov 11, 4:33*pm, Buckbuck <buck.matthe... (AT) yahoo (DOT) com> wrote:
Solved this - thanks
Matthew

"Buckbuck" <buck.matthew74 (AT) yahoo (DOT) com> wrote

Checkbox Fields which can only have a single value are easy - set the Field
to the appropriate value. (Single value checkbox Field should really be
radio button Fields.)
i.e.
If (IsEmpty(TaxNumber); "N"; "Y")
or
If (Not(IsEmpty(TaxNumber); "Y"; "N")
or
If (TaxNumber = ""; "N" ; "Y")
or
If (TaxNumber <> ""; "Y"; "N")

It's when the checkbox Field can contain multiple values that it gets a bit
tricky. You have to remember that each value must be separated by a carriage
return, and that there may already be other values in the field that need to
be retained when you add / check a new value.

Helpful Harry )

"Buckbuck" <buck.matthew74 (AT) yahoo (DOT) com> wrote

Matthew,

i hope you don't mind that I give some general advise for posting questions
to the group.
It might help us (me certainly) if you post your question with examples of
what you have tried.
That way we might understand your reasoning and guide you along.
And when you solved something adding that to your post might be of some
assistance to someone else.

--

Hou je goed / keep well,

Ursus