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