Infomaker update field

Hi All,

I've created a new infomaker custom screen based on a new local table. I have one field which is defined as char(1) and is formatted as check box. When I load the form and update the check box with a tick, the database contains a 'Y' and the record will re-display correctly. However, I'm not able to uncheck the box. I can change the data in the other fields, but not the check box. If I re-set it back to 'N' in the database, it will display correctly as an empty box. I can then update it by checking the box again, but not uncheck it.

All the permissions appear correct in the local table. I've compared the properties of the infomaker field with others that are working and can't see the difference. Is there an 'Allow updates' field I'm missing somewhere? Or is there more to it than that.

I just know someone will have the answer.

Thanks

Debbie

Parents Reply Children
  • Rats. Thanks for replying though! I've put in a ticket.

    Edited to add: AHA! I found the answer.

     

    Infomaker had added infomaker columns for the new fields off to the far right that I didn’t notice. I put my own copies of the columns on there and made them into checkboxes. But those extra copies of the field that had been auto-added were keeping the copies I put in place from working. When I deleted those it made my versions work.

    Odd!



    [edited by: Andrea Crain at 5:04 PM (GMT -6) on 18 Mar 2015] found solution!