I am trying to build a controlsource for a checkbox that will work with two different possible sets of tables.

IIF([type(empdrvr.callboard) = "L"], empdrvr.callboard, IIF([empdrvr.callboard = 1], .T., .F.))

In one set, the empdrvr.callboard is a logical datatype, in the other set, empdrvr.callboard is a numeric N(1,0).

Can anyone see where I have typed something wrong, before I do. I know it is going to be something simple that I am missing.

TIA
Beth